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-value1.69236030903034p-value0.994940555492517ConclusionDo Not Reject Null HypothesisUpper one-tailed testCritical t-value1.69236030903034p-value0.005059444507483ConclusionReject Null HypothesisTwo-tailed testCritical t-value (+ and -)2.03451529744934p-value0.010118889014965ConclusionReject 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 "=(B4-B5)/SQRT((B5*(1-B5)/B3))"One tailed z-value1.644854 "=NORM.S.INV(1-B6)"Two tailed z-value (+ and -)1.959964 "=NORM.S.INV(1-B6/2)"

Hypothesis test results