Confidence Intervals Using Excel

Courtesy of Maryann Babcock, Western Michigan University
  1. Calculating the Confidence Interval Estimate for the Mean when sigma is unknown

    Use the interval estimate Excel function t-confidence interval.xls from the Stat 216 web-site.   Copy your data and paste it into column E of this worksheet.

  2. Calculating the Confidence Interval Estimate for the Proportion

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

Back to the top of the page
Back to the Stat 216 Home Page
Statistics Home Page
Western Michigan University Homepage

e-mail:  Stat 216 Instructor
URL:  http://homepages.wmich.edu/~lheun/S216CItip.html
Last modified: