Hypothesis Test Using Excel

Courtesy of Maryann Babcock, Western Michigan University

---

One-Sample Hypothesis Tests

1. Performing the t Test of Hypothesis for the Mean when sigma is unknown

   Retrieve the Hypothesis t-test.xls model from the Stat 216 web-site.   Copy your data and paste it into this worksheet.

Two-Sample Hypothesis Tests with Independent Sample Data

1. Performing the Pooled-Variance t Test of Hypothesis for the Differences in two Means (pp. 122)

   Tools | Data Analysis | t-Test: Two-Sample Assuming Equal Variances

   Follow the instructions in paragraph 8.3.1 on page 122 but insert information for your problem.

Two-Sample Hypothesis Tests with data from Dependent Samples

1. Performing the t Test of Hypothesis for the Mean Difference (pp. 122)

   Tools | Data Analysis | t-Test: Paired Two Sample for Means

   Follow the instructions in paragraph 8.3.2 on page 122 but insert information for your problem.