Data Driven A

profilekimdevore
cf_MAT210_Week_9_Data-Set_MGT_rev.xlsx

Calculator

Sample Number Ounces in Bag Minimum 19.02
1 20.56 Maximum 20.79
2 19.37 Q 1 19.66
3 20.01 Q 2 19.925
4 19.99 Q 3 20.1725
5 19.65
6 19.94
7 19.47
8 20.19
9 19.72
10 19.51
11 19.52
12 19.99
13 20.28
14 19.02 Student should Use t-test
15 20.79 Mean 19.92
16 19.47 Median 19.9250
17 20.67 Standard Deviation 0.402598
18 19.69 n= 30
19 20.12 df= 29
20 20.29 Confidence Level= 0.95
21 19.92 t= 2.045
22 19.79 E= 0.150333
23 19.72 Confidence Interval Lower Limit 19.76767
24 19.92 Confidence Interval Upper Limit 20.0683
25 20.39 Null Hypothesis µ=20
26 19.49 Alternative Hypothesis µ<20
27 19.92 What type of Test Statistic did you use and why? t-test; population standard deviation not given
28 19.93
29 19.98
30 20.23
Conclusion: Is the claim supported? Why or why not? Fail to reject the null so there is not enough evidence to reject the hypothesis; we cannot support this claim.
If student uses z-test; provide feedback and grade for content.
Hypothesis Test
Null Hyp: m = 20 ← In cell C18, select the correct equality/inequality, enter null value in D18
= Alt Hyp: m < 20 ← In cell C19, select the correct inequality, enter same null value in D19
significance level = 0.05 ← Enter the level of significance of the test.
test statistic = -1.11558
< critical value = -1.69913
> p-value = 0.13688
Since 0.1368797045 > 0.05 we fail to reject the null: m = 20