| Inferences About One Population Mean - Hypothesis Testing |
| This worksheet provides a template for testing a hypothesis about one population mean. |
| Fill in H0, a, sample information and population standard deviation (if available) in the blue-colored cells. |
| Hypothesis Testing: |
| Hypothesized null value (H0) | 4 |
| Significance level a | 0.05 |
| Evidence from the Sample: |
| Sample Mean (X_bar) | 4.4 |
| Sample Standard Deviation (s) | 1.747585 |
| Sample Size (n) | 75 |
| Case 1 (Population Standard Deviation is known) |
| Population Standard Deviation | 1.747585 |
| "Evidence" (sample mean) | 4.4000 |
| Standard error | 0.2018 |
| z Statistic | 1.9822 |
| | Lower-tailed Test | Upper-tailed Test | Two-tailed Test |
| Alternative Hypothesis (Ha) | mean < 4 | mean > 4 | mean <> 4 |
| p-Value | 0.9763 | 0.0237 | 0.0475 |
| z Critical Value | -1.6449 | 1.6449 | +/-1.96 |
| Case 2 (Population Standard Deviation is unknown) |
| Population Standard Deviation | N/A |
| "Evidence" (sample proportion) | 4.4000 |
| Standard error | 0.2018 |
| Degrees of freedom | 74.0000 |
| t Statistic | 1.9822 |
| | Lower-tailed Test | Upper-tailed Test | Two-tailed Test |
| Alternative Hypothesis (Ha) | mean < 4 | mean > 4 | mean <> 4 |
| p-Value | 0.9744 | 0.0256 | 0.0512 |
| t Critical Value | -1.6657 | 1.6657 | +/-1.9925 |
dennis teow
excel_template_hypothesis_testing.xlsx
