Summary Statistics for weekly amount of sales ($ '000) by market size Statistics Small sales Medium...

Transcribed Image Text:

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 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