A B C D


1
Single Value Uniform Bimodal


2
5 2 2


3
5 4 2


4
5 6 8


5
5 8 8


6






7 count n 4 4 4 =COUNT(B2:B5)

8 min 5 2 2 =MIN(B2:B5)

9 max 5 8 8 =MAX(B2:B5)

10 range 0 6 6 =MAX(B2:B5)-MIN(B2:B5)

11 sum 20 20 20 =SUM(B2:B5)

12






13 median 5 5 5 =MEDIAN(B2:B5)

14 mode 5 #VALUE! 2 =MODE(B2:B5)

15 mean 5 5 5 =AVERAGE(B2:B5)

16






17 pop stdev 0 2.24 3 =STDEVP(B2:B5)

18 samp stdev 0 2.58 3.46 =STDEV(B2:B5)

19






20 pop var 0 5 9 =VARP(B2:B5)

21 samp var 0 6.67 12 0

22






23 Coef of Var 0 0.52 0.69 =STDEV(B2:B5)/AVERAGE(B2:B5)

24

52% 69%


25






26 Bin Upper Limit SV Freq Uniform Freq Bimodal Freq


27 2 0 1 2


28 3 0 0 0


29 4 0 1 0


30 5 4 0 0


31 6 0 1 0


32 7 0 0 0


33 8 0 1 2


34 Sum (count n): 4 4 4


35
36
37
38
39
40
41
42
43
44
45
46
47
48