W7 HW.xlsx - One Sample Test for the Mean Sample Size...

• Homework Help
• 13
• 100% (34) 34 out of 34 people found this document helpful

This preview shows page 1 - 5 out of 13 pages.

One Sample Test for the Mean Sample Size 34 Sample Mean 38.677 Sample Standard Deviation 7.858 Hypothesized value 35 Level of significance 0.05 t-statistic 2.728482 Use "=(B4-B6)/(B5/SQRT(B3))" One tailed t-value 1.69236 Use "=T.INV(1-B7,B3-1)" Two tailed t-value (+ and -) 2.034515 Use " =T.INV.2T(B7,B3-1)"
Hypothesis test results (Vacation Survey Example) Lower one-tailed test Critical t-value -1.692360309 p-value 0.0050594445 Conclusion Reject Null Hypothesis Upper one-tailed test Critical t-value -1.692360309 p-value 0.0050594445 Conclusion Two-tailed test Critical t-value (+ and -) -2.0345152974 p-value 0.010118889 Conclusion Reject Null Hypothesis
"=-B10" Use " =T.DIST(\$B\$9,\$B\$3-1,TRUE)" Use "=IF(F5<B7,"Reject Null Hypothesis","Do Not Reject Null Hypothesis")" "=-B10" Use "=1-T.DIST(\$B\$9,\$B\$3-1,TRUE)" Use "=IF(F10<B7,"Reject Null Hypothesis","Do Not Reject Null Hypothesis")" "=-B11" Use "=IF(B9>0, T.DIST.2T(B9,B3-1), T.DIST.2T(-B9,B3-1))" Use "=IF(F15<B7,"Reject Null Hypothesis","Do Not Reject Null Hypothesis")"
One Sample Test for the Proportion Sample Size 44 Sample Proportion 0.795 Hypothesized value 0.75 Level of significance 0.05 z-statistic 0.689348 "=(B4-B5)/SQRT((B5*(1-B5)/B3))"
• • • 