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)"