MAT300: Assignment 1: Bottling Company Case Study

profilenatrod
mat300_writing_assignment_excel_template_v2.xlsx
Home>Mathematics homework help>MAT300: Assignment 1: Bottling Company Case Study

Sheet1

Hypothesis Test H0: µ=15 15
Observation Number Data H1: µ<15
1 15
2 15 Mean 15.1666666667 Cells in Blue need to be keyed
3 14.9 Standard Deviation 0.6944773939 Cells in Orange are formulas
4 15
5 15 T Test Statistic 1.314
6 15 T Crit Value(alpha=.05) 1.6991270265
7 15 T Crit Value(alpha=.025) 2.0452296421
8 14.1
9 15 P-Value 0.0994946307
10 15 95% CI
11 15 Lower Bound 14.907344546
12 15 Upper Bound 15.4259887874
13 17
14 15
15 15
16 16
17 15
18 15
19 15
20 18
21 15
22 15
23 15
24 15
25 15
26 15
27 15
28 15
29 15
30 15

Sheet2

Sheet3