30.00% 25.00% 20.00% 20.00% 18.00% Percentage distribution of large market size 16.00% 14.00% 12.00% 10.00% 8.00% 6.00% 4.00% 2.00% 0.00% 38-44 44-50 50-56 56-62 92-98 98-104 62-68 68-74 74-80 Sales amount of large amount size 80-86 Percentage distribution of medium market size 76-98 15.00% 10.00% 5.00% 0.00% 15-21 21-27 27-33 33-39 39-45 45-51 51-57 57-63 63-69 Sales amount of medium market size 30.00% 25.00% 20.00% 15.00% 10.00% 5.00% Percentage distribution of small market size 0.00% 35-40 40-45 45-50 50-55 55-60 60-65 65-70 70-75 Sales amount of small market size Total Total Total Table 2(a) for small market size sales Small market size sales ($'000) Count of Small market size sales 35-40 40-45 45-50 50-55 55-60 60-65 65-70 70-75 Grand Total Table 2(b) for medium market size sales 1.67% 1.67% 10.00% 23.33% 25.00% 25.00% 11.67% 1.67% 100.00% Medium market size sales ($'000) Count of Medium market size sales 15-21 21-27 27-33 33-39 39-45 45-51 51-57 57-63 63-69 Grand Total 0.63% 3.13% 8.75% 15.63% 23.44% 25.63% 16.88% 4.69% 1.25% 100.00% Table 2(c) for large market size sales Large market size sales ($'000) Count of Large market size sales 38-44 2.98% 44-50 12.50% 50-56 15.48% 56-62 8.33% 62-68 8.33% 68-74 1.19% 74-80 10.12% 80-86 19.05% 86-92 13.69% 92-98 7.14% 98-104 1.19% Grand Total 100.00% Summary Statistics for weekly amount of sales ($ '000) by market size Statistics Small sales Medium sales Large sales Excel Function Used for medium market size (including cell references) Mean 57.41 43.99 70.12 =AVERAGE(C2:C321) Median 57.56 44.59 75.02 =MEDIAN(C2:C321) Standard Deviation 6.63 9.05 17.05 =STDEV(C2:C321) Minimum 36.17 17.34 39.36 Maximum 70.60 65.11 99.65 Range 34.43 47.77 60.29 =19-18 Count 60 320 168 |=MIN(C2:C321) |=MAX(C2:C321) =COUNT(C2:C321) |=QUARTILE.EXC(C2:C3 First Quartile 53.21 37.91 53.55 21,1) |=QUARTILE.EXC(C2:C3 Third Quartile 62.16 50.44 84.92 21,3+11) Interquartile Range (IQR) 8.95 12.53 31.37 =113-112 Coefficient of Variation (CV) 11.55% 20.58% 24.32% =17/15