ExampleAJOHNSON_MTH156_DISC2-11.xls
Sheet1
| | BEER CO DATA 2017 | BEER CO DATA 2018 | | Description | 2017 | 2018 |
| Month | KW Demand/Month | KW Demand/Month | | Sum of Samples | 849 | 828 |
| Oct | 80 | 62 | | Mean | 84.9 | 82.8 |
| Sept | 87 | 87 | | Median | 82 | 85 |
| Aug | 85 | 85 | | Sample | 10 | 10 |
| Jul | 96 | 95 |
| Jun | 84 | 93 | | Standard Deviation | 17.919 | 16.748 |
| May | 100 | 82 | | Sample Variance | 321.11 | 280.5 |
| Apr | 78 | 81 |
| Mar | 79 | 87 | | Maximum | 100 | 95 |
| Feb | 80 | 85 | | Minimum | 78 | 62 |
| Jan | 80 | 71 | | Range | 22 | 33 |
| MEAN | 84.9 | 82.8 |
| | | | | | 2017 | 2018 |
| | | | | | 432.64 | 47.61 |
| | | | | | 139.24 | 34.81 |
| | | | | | 3.24 | 24.01 |
| | | | | | 0.64 | 24.01 |
| | | | | | 4.84 | 24.01 |
| | | | | | 4.84 | 0.81 |
| | | | | | 17.64 | 0.01 |
| | | | | | 17.64 | 0.001 |
| | | | | | 104.04 | 123.21 |
| | | | | | 148.84 | 228.01 |
| | | | | Sample Variance | 321.18 | 280.50 |
| | | | | Standard Deviation | 17.9215 | 16.7481 |
| | | | | Coefficient of Variation | 21.11% | 20.23% |
jimmh.picholsa9u9
