Miller, Katherine Louise L.
Santos, Danielle Katrina M. November 27, 2013
UV-2L Mango
Exercise 1: Descriptive Analysis- Data Collection and Presentation
Table 1. Statistical profile of mango, Philippines, 1990-2012 | Productiona (metric tons) | Importsb (metric tons) | Exportsc (metric tons) | Per capita consumptiond (kg/yr) | National populatione (in millions) | Wholesale pricesf (Php/metric ton) | Area plantedg (hectares) | Substitute: Papayah (Php/metric ton) | 1990 | 453,986.23 | nd | 11,760.74 | nd | nd | nd | 77,136.87 | nd | 1991 | 480,395.73 | nd | 20,344.52 | nd | nd | 18,022.79 | 82,515.18 | 2,899.08 | 1992 | 519,840.95 | nd | 24,606.48 | nd | nd | 16,016.58 | 86,127.35 | 3,913.21 | 1993 | 544,605.96 | nd | 27,489.51 | nd | nd | 17,118.89 | 91,212.95 | 4,916.31 | 1994 | 623,192.16 | nd | 26,367.32 | nd | nd | 20,238.44 | 99,111.57 | 5,390.30 | 1995 | 697,065.71 | nd | 39,858.98 | nd | nd | 11,567.65 | 108,144.37 | 5,041.20 | 1996 | 787,160.44 | nd | 36,516.00 | nd | nd | 14,355.73 | 117,434.67 | 4,534.14 | 1997 | 990,246.06 | nd | 40,767.98 | nd | nd | 11,803.55 | 124,947.06 | 5,331.55 | 1998 | 994,001.93 | nd | 47,698.87 | nd | nd | 13,721.57 | 129,795.72 | 8,822.13 | 1999 | 866,187.15 | nd | 31,844.00 | 39.00 | nd | 21,671.44 | 132,232.16 | 6,066.35 | Table 1. Continued. | | | | | | | | | 2000 | 848,328.27 | nd | 36,315.51 | 39.00 | 81,159,650 | 17,552.10 | 133,814.80 | 6,709.44 | 2001 | 881,709.64 | nd | 34,947.48 | nd | 82,841,520 | 14,608.93 | 137,050.00 | 6,599.21 | 2002 | 956,033.14 | nd | 32,845.53 | nd | 84,525,640 | 15,120.40 | 150,505.00 | 6,026.01 | 2003 | 1,006,190.52 | nd | 34,746.99 | nd | 84,619,980 | 14,330.05 | 155,852.49 | 6,408.07 | 2004 | 967,472.54 | nd | 32,404.64 | nd | 86,241,700 | 17,063.78 | 158,942.61 | 8,006.42 | 2005 | 984,341.88 | nd | 29,424.54 | nd | 87,857,470 | 16,531.36 | 164,100.84 | 8,076.30 | 2006 | 919,029.99 | nd | 24,818.76 | nd | 89,468,680 | 17,328.33 | 171,710.78 | 7,198.09 | 2007 | 1,023,906.89 | nd | 26,314.71 | nd | 91,077,290 | 16,736.39 | 184,173.85 | 7,330.37 | 2008 | 884,011.25 | nd | 19,842.85 | 53.61 | 96,061,680 | 19,547.29 | 186,770.16 | 6,429.78 | 2009 | 771,441.44 | nd | 19,479.07 | 53.61 | 97,976,600 | 19,232.03 | 188,139.01 | 7,501.23 | 2010 | 825,676.06 | nd | 21,536.57 | nd | 99,900,180 | 19,558.31 | 189,436.74 | 8,394.10 | 2011 | 788,073.56 | nd | 27,728.10 | nd | 101,833,900 | 19,944.12 | 187,072.73 | 9,182.25 | 2012 | 768,234.49 | nd | nd | 58.15 | 103,775,000 | nd | 188,616.99 | nd |

a- BAS.2013. Accessed November 16. http://countrystat.bas.gov.ph/?cont=10&pageid=1&ma=A60PNVOP b- No Data Available c- FAOSTAT. 2013. Accessed November 16. http://faostat.fao.org/site/342/default.aspx d- BAS. 2013. Accessed November 16. http://countrystat.bas.gov.ph/?cont=10&pageid=1&ma=I90FCPCC e- IndexMundi.2013. Accessed November 23. http://www.indexmundi.com/g/g.aspx?c=rp&v=21 f- FAOSTAT.2013. Accessed November 16. http://faostat.fao.org/site/703/DesktopDefault.aspx?PageID=703#ancor g- BAS. 2013. Accessed November 16. http://countrystat.bas.gov.ph/?cont=10&pageid=1&ma=P00LUAHO h- FAOSTAT.2013. Accessed November 16. http://faostat.fao.org/site/703/DesktopDefault.aspx?PageID=703#ancor
Table 2. Summary statistics of Mango, | Production (metric tons) | Imports (metric tons) | Exports (metric tons) | Per capita consumption (kg/yr) | National population (in millions) | Wholesale prices (Php/metric ton) | Area planted (hectares) | Substitute: Papaya (Php/metric ton) | Mean | 807,875.30 | nd | 28,159.09 | 48.67 | 91,333,791.54 | 16,765.23 | 141,080.17 | 6,417.88 | Standard Error | 37,095.17 | nd | 2,132.46 | 4.04 | 2,138,648.41 | 600.00 | 7,944.00 | 359.24 | Minimum | 453,986.23 | nd | 11,760.74 | 39.00 | 81,159,650.00 | 11,567.65 | 77,136.87 | 2,899.08 | Maximum | 1,023,906.89 | nd | 47,698.87 | 58.15 | 103,775,000.00 | 21,671.44 | 189,436.74 | 9,182.25 |

Figure 1. Relationship between wholesale prices and volume of production of mango, 1990-2012

References:
Bureau of Agricultural Statistics. 2013. “CountryStat Philippines”. Accessed November 16. http://countrystat.bas.gov.ph/
Food and Agriculture Organization of the United Nations. “Trade”. Accessed November 16. http://faostat.fao.org/site/342/default.aspx
Food and Agriculture Organization of the United Nations. “Prices”. Accessed November 16. http://faostat.fao.org/site/342/default.aspx
IndexMundi. “Demographics: Population”. Accessed November 23. http://www.indexmundi.com/philippines/population.html