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