A B C D
1
Single Value Uniform Bimodal
2
5 1 1
3
5 2 1
4
5 3 1
5
5 4 2
6
5 5 5
7
5 6 8
8
5 7 9
9
5 8 9
10
5 9 9
11



Contents of Column B:
12 count n 9 9 9 =COUNT(B2:B10)
13 min 5 1 1 =MIN(B2:B10)
14 max 5 9 9 =MAX(B2:B10)
15 range 0 8 8 =MAX(B2:B10)-MIN(B2:B10)
16 sum 45 45 45 =SUM(B2:B10)
17




18 median 5 5 5 =MEDIAN(B2:B10)
19 mode 5 #VALUE! 1 =MODE(B2:B10)
20 mean 5 5 5 =AVERAGE(B2:B10)
21




22 samp stdev 0 2.74 3.77 =STDEV(B2:B10)
23 samp var 0 7.50 14.25 =VAR(B2:B10)
24




25 Coef of Var 0 0.55 0.75 =STDEV(B2:B10)/AVERAGE(B2:B10)
26

55% 75%
27




28 Bin Upper Limit SV Freq Uniform Freq Bimodal Freq
29 1 0 1 3
30 2 0 1 1
31 3 0 1 0
32 4 0 1 0
33 5 9 1 1
34 6 0 1 0
35 7 0 1 0
36 8 0 1 1
37 9 0 1 3
38 Sum (count n): 9 9 9