Hypothesis Testing (One Sample/Proportions)

WK 6 SOCI332 

Excel Directions: 

1. State your null and alternative hypotheses in text. 
2. Use Data → Data Analysis → t-Test: Two-Sample Assuming Equal Variances (or appropriate variant) if Analysis ToolPak is enabled. Or use built-in functions: 
   1. =T.TEST(range1, range2, tails, type) 
   2. For one-sample: compute t = (mean – μ₀) / (stdev / SQRT(n)). 
3. Use =T.DIST.2T(|t|, df) or =T.DIST.RT(|t|, df) for p-value (two-tail or right-tail). 
4. Compare p-value to α. Make decision. 
5. Report test statistic, degrees of freedom, p-value in Excel, and interpretation in a write-up. 
6. Use cell references for all calculations.