Assignment 1: Bottling Company Case Study

profileASAPsolution
MAT_300_Assignment_Bottling1.xlsx

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

Sheet2

Sheet3