Data1 Data2 2013 Food Cetegry Beverages Cereals and bakery Coooa and chocolat P
ID: 3046083 • Letter: D
Question
Data1 Data2 2013 Food Cetegry Beverages Cereals and bakery Coooa and chocolat P P 27775. 286GO 3,0010 34453 3,722.5. 4,0 6 43301 5,063 7-0.554. D 7,930 ,| 7,0568 73295 1,2041 0.500.7, to 52251.4045 1,535.9 1,7609 2,4392 2484 4 2,7506 2.669 22,661.6 3,2988 3,4762 295 2 4,6806 40 seas 7 s441.8 2.400 7. 24560 2.671.9 3,1443: 37708 4194. 4,791.2 5seo a 5160 62650 ,71S8, 872S,- 7 93039223 00 1,1103 1.22 3 13884 1405,503 81,595 13534 134 2 5021 8040 A8 933 10,511,311 13123 13446 13120 133 45167164416,46717 4793 7 4647 4 4.677 7 5.080 7 5.599 5 5976 4 6.90,3 737.9 9.257.5, 9919 3 9.660 5 106eso: 12.0064, 12.5095 13 25 130 2M8 2 3.024.5 1274 9 3.632.B 3,979 2 44369 6.126.8 6,034.0 6,315, 51727 5550.1 6.670.11 7.902.7- 1.191.7 1A2 1.5 ,773.31 1.7270 1,200,3 1,1» 0 14765 2,1772. 2.502.4· 2,2006 1450.3 2,0,1 01 1,890.5 2's., z 3258, 3825 9 42536 4,280 5 4,424 6 5716. 8 57500 524 1.3 s,M64 S0579 4607 9 5045 7 5,7530 EN 24 6 Other edble produsP Sugse and eandy Vegetable ois Vegetables 852 89547455 778.1 5 1,1850 1260 12447 1,35.0 15555 14771665 2 2.1704 23142 2121, 2.100 o 2.20, 6 2.478 0 3.619 9 4.7486, 54567| 5.M77 6.057.2 6.0097 63904 6.7635 '096 9 11.010 s-, 531560910.1.00042,1362,11432. 63 2,00. 2.5 01 400.1 $,101.9 4.02.4 467 14481 12379 13611.5872.3224977 2.9362 3,677.2 69426 4.1960 4,7012 702 6,476.9 627 7674 4,152.143864 ,078.1 5724035,611 7,2443 7,7873 5033 8683 49,6320 9,881.5 10 Taible can to found at http wwww.ersunda ovidata-productolus-food-imports asp ANSWER THE FOLLOWING QUESTIONS ON THIS SHEET PLUS THOSE ON THE NENTSHEET AS WELL USING THE DATA ABOVE Use countit to detenmine how many food categories are classitied as pla 2) Take the salue in cell H8 and round it to the nearet hundredth co hundrod (160) )For the category of Cocoa and Chocolate from 1999-2013, find the bollowing The Inmerquartil: Range Samplc Variance Sample Standard Deviatien Are there any ostliers? Why or why not Create a "stacked column in 3Dgraph foe your data set What daes the beight of each colaan reprosean? Why de yis suppose there was the dip in 2009 and 2010Explanation / Answer
1)
=COUNTIF(B2:B16,"P")
2)
=ROUNDDOWN(H8,2)
=ROUNDDOWN(H8,0)
3)
=AVERAGE(D5:R5)
=MEDIAN(D5:R5)
=MAX(D5:R5)
=MIN(D5:R5)
Range=Max-Min
=QUARTILE.INC(D5:R5,1)
=QUARTILE.INC(D5:R5,3)
IQR=QUARTILE.INC(D5:R5,3)-QUARTILE.INC(D5:R5,1)
=VAR.S(D5:R5)
=STDEV.S(D5:R5)
If there is any value which is below first quartile – 1.5·IQR or third quartile + 1.5·IQR, it is considered an outlier.
4)
Stacked column will show the share of each year for each food category. A dip in 2009 and 2010 could be because of the recession in the US economy.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.