# A.docx - Question 1 a 1.The annual sales of products in...

• 6

This preview shows page 1 - 3 out of 6 pages.

Question 1 a.1.The annual sales of products in Melbourne are 7.32(‘000).The Excel function used to find the annual sales in Melbourne is:=VLOOKUP (4078554, A1:L401,2, FALSE)2.The average sales in non-US stores are 6.8230(000)The sales in Melbourne higher than the average sales in non-US storesExcel function=AVERAGEIF(\$K1:\$K401,"=no",\$B1:\$B401)b.c.0-22-44-66-88-1010-1212-1414-1616-180.00%5.00%10.00%15.00%20.00%25.00%30.00%1.55%6.20%20.54%24.03%22.48%16.67%7.75%0.39%0.39%Percentage frequency histogram of domestic market sales(US)Sales('000)Percentage frequencySales (‘000 seats)Domestic (US) Overseas (non-US)Mean 7.876.82Median7.796.66Standard Deviation 2.882.60First Quartile 5.735.07Third Quartile 10.008.54Inter Quartile Range 4.273.47Range 15.9014.90Minimum 0.370.00Maximum 16.2714.90Coefficient of Variation 36.57%38.14%
0-22-44-66-88-1010-1212-1414-160.00%5.00%10.00%15.00%20.00%25.00%30.00%35.00%2.11%9.15%28.87%30.99%19.01%6.34%2.11%1.41%Percentage frequency histogram of overseas markets sales (non-US) Sales('000)Percentage frequencyd.From central tendency:Based on mean statistics US (7870) is higher than non-US (6820).Median: US (7790) is higher than non-US (6660).The most modal class is 6000-8000 for both markets.Overall, the baby seats sales for US is higher than non-US.From variabilityThe range of sales for US (15.9) is larger than non-US (14.9).