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