22.7 53.8 45 50.3 50 22 55.6 49.9 15.9 42.8 44.3 45.2 35.1 39.700000000000003 70.099999999999994 53.6 10 33 46 46.8 60 1 0.01 48.2 2 48 3 45.9 4 75.599999999999994 5 62.3 6 37 7 67.900000000000006 8 18.5 9 22.9 48.3 40.4 67.8 45 46.8 64.900000000000006 66.7 85.3 61.7 63.7 63.7 46.9 59.3 33 65 34.700000000000003 42.7 80.8 27.3 45.8 73.5 78.599999999999994 62.6 53.6 54 58.7 42.3 35.5 40.200000000000003 31.7 26.4 36.6 51.1 39.299999999999997 82.2 65.3 53.6 45.5 28.6 45.1 59 45.2 53.4 50.3 62.4 38.6 62.3 37 61.1 61.4 31 31.7 41.1 13.7 42.1 37.4 75.900000000000006 62.5 86.8 51.3 70.099999999999994 64.2 40.200000000000003 35.299999999999997 48.1 75.2 32.700000000000003 1 0.01 59.4 2 45.7 3 25.2 4 56.4 5 6 7 8 9 Using Microsoft Excel for Descriptive Sample Statistics – Shop Sales Example This worksheet contains numerical descriptive statistics and histograms and ogives produced using Excel. Suppose the sales values below have been recorded during the day in a small shop. Describe the data. Put your formulae/answers in the shaded cells. 1) Descriptive sample statistics using raw data n min mean max median Five-point summary mode range first quartile MAD MAD: mean average deviation variance samp sample third quartile variance popl population) St Dev samp St Dev popl IQR CV (coef of variation) Inner fences Outer fences kurtosis Data Grouping class width Class Lower Upper Midpoint Frequency Cumulative class limit M f £ SUM: HISTOGRAM: Put histogram here ê 2) description here è Put descriptive analysis here ê Cumulative Frequencies 3) Data for Ogive Relative class boundary Rf CRf 3a) 3b) 3c) 4a) 4b) 4c) Put Ogives here ê skewness RawData