# Wk7 Homework.xlsx - One Sample Test for the Mean Sample...

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

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

One Sample Test for the MeanSample Size34Sample Mean38.677Sample Standard Deviation7.858Hypothesized value35Level of significance0.05t-statistic2.728482Use "=(B4-B6)/(B5/SQRT(B3))"One tailed t-value1.69236Use "=T.INV(1-B7,B3-1)"Two tailed t-value (+ and -)2.034515Use " =T.INV.2T(B7,B3-1)"
Hypothesis test results(Vacation Survey Example)Lower one-tailed testCritical t-value-1.692360309p-value0.9949405555ConclusionDo Not Reject Null HypothesisUpper one-tailed testCritical t-value-1.692360309p-value0.0050594445ConclusionReject Null HypothesisTwo-tailed testCritical t-value (+ and -)-2.0345152974p-value0.010118889ConclusionReject 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 ProportionSample Size44Sample Proportion0.795Hypothesized value0.75Level of significance0.05z-statistic0.689348