Assignment 1: Bottling Company Case Study
bilnag
bottling_company_excel_solutions.xlsx
Sheet1
| | bottle number | ounces |
| | 1 | 14.23 |
| | 2 | 14.32 |
| | 3 | 14.98 |
| | 4 | 15 |
| | 5 | 15.11 |
| | 6 | 15.21 |
| | 7 | 15.42 |
| | 8 | 15.47 |
| | 9 | 15.65 |
| | 10 | 15.74 |
| | 11 | 15.77 |
| | 12 | 15.8 |
| | 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 |
| | | Mean | 15.854 |
| | | Median | 15.99 |
| | | Standard deviation | 0.6613810003 |
| | | Confidence interval |
| | | Upper bound | 16.1009359947 |
| | | Lower bound | 15.6070640053 |
| | | Confidence interval | (15.61,16.10) |
