Vasquez-Wk7.xlsx - One Sample Test for the Mean Sample Size...

This preview shows page 1 - 5 out of 15 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.69236030903034 p-value 0.994940555492517 Conclusion Do Not Reject Null Hypothesis Upper one-tailed test Critical t-value -1.69236030903034 p-value 0.005059444507483 Conclusion Reject Null Hypothesis Two-tailed test Critical t-value (+ and -) -2.03451529744934 p-value 0.010118889014965 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))" One tailed z-value 1.644854 "=NORM.S.INV(1-B6)" Two tailed z-value (+ and -) 1.959964 "=NORM.S.INV(1-B6/2)"

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture