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