A B C D
1
Single Value Uniform Bimodal
2
5 3 3
3
5 4 3
4
5 5 5
5
5 6 7
6
5 7 7
7



Contents of Column B:
8 count n 5 5 5 =COUNT(B2:B6)
9 min 5 3 3 =MIN(B2:B6)
10 max 5 7 7 =MAX(B2:B6)
11 range 0 4 4 =MAX(B2:B6)-MIN(B2:B6)
12 sum 25 25 25 =SUM(B2:B6)
13




14 median 5 5 5 =MEDIAN(B2:B6)
15 mode 5 #VALUE! 3 =MODE(B2:B6)
16 mean 5 5 5 =AVERAGE(B2:B6)
17




18 pop stdev 0 1.41 1.79 =STDEVP(B2:B6)
19 samp stdev 0 1.58 2.00 =STDEV(B2:B6)
20




21 pop var 0 2 3.2 =VARP(B2:B6)
22 samp var 0 2.50 4 =VAR(B2:B6)
23




24 Coef of Var 0 0.32 0.40 =STDEV(B2:B6)/AVERAGE(B2:B6)
25

32% 40%
26




27 Bin Upper Limit SV Freq Uniform Freq Bimodal Freq
28 3 0 1 2
29 4 0 1 0
30 5 5 1 1
31 6 0 1 0
32 7 0 1 2
35 Sum (count n): 5 5 5