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