| Confidence Interval for Population Proportion | | Notes |
| Number of successes in sample | 60 | sample sucesses |
| Sample size, n | 150 | Total number of samples |
| confidence level, c | 0.95 |
| sample proportion, p | 0.4 | Number of successes/sample size |
| critical z value, z | 1.9599639845 | Uses the NORMSINV function in excel; NORMSINV((1+c)/2) |
| standard error, SE | 0.04 | SQRT(p*(1-p)/n) |
| margin of error, MOE | 0.0783985594 | z * SE |
| lower confidence limit | 0.3216014406 | p - MOE |
| upper confidence limit | 0.4783985594 | p + MOE |
| Enter data highlighted in yellow. Rows 5 through 10 are calcualted using data from rows 2 through 4. |
| | Confidence interval= | 0.321601441 ≤p≤ 0.478398559 |
Lisa ap
critiqueandrevisethiscopy.ExceltemplateforCIwithanexample.xls
