Assignment 1: Bottling Company Case Study
Sheet1
| Bottle Number | Ounces | ||||
| 1 | 14.23 | ||||
| 2 | 14.32 | ||||
| 3 | 14.98 | Mean | 15.85 | ||
| 4 | 15 | Median | 15.99 | ||
| 5 | 15.11 | Standard Deviation | 0.6613810003 | ||
| 6 | 15.21 | S.D/√n | 0.1208 | ||
| 7 | 15.42 | t*S.D/√n | 0.2470 | ||
| 8 | 15.47 | ||||
| 9 | 15.65 | test value | 1.209 | ||
| 10 | 15.74 | ||||
| 11 | 15.77 | Lower Limit | Upper Limit | ||
| 12 | 15.8 | Confidence interval | 15.607 | 16.101 | |
| 13 | 15.82 | ||||
| 14 | 15.87 | ||||
| 15 | 15.98 | ||||
| 16 | 16 | ||||
| 17 | 16.02 | ||||
| 18 | 16.05 | ||||
| 19 | 16.21 | ||||
| 20 | 16.21 | ||||
| 21 | 16.23 | ||||
| 22 | 16.25 | ||||
| 23 | 16.31 | ||||
| 24 | 16.32 | ||||
| 25 | 16.34 | ||||
| 26 | 16.46 | ||||
| 27 | 16.47 | ||||
| 28 | 16.51 | ||||
| 29 | 16.91 | ||||
| 30 | 16.96 | ||||