If X = 125, S = 24, N = 36, use the template below to
calculate CI. Then, show the equation.
***Perform the calculation using a 99% level of
confidence instead of normal distribution.
Confidence Estimate for the Mean
Data
Population Standard Deviation
Sample Mean
Sample Size
Confidence Level
Intermediate Calculations
Standard Error of the Mean #DIV/0!
Z Value 0.0000
Interval Half Width #NUM!
Confidence Interval
Interval Lower Limit #NUM!
Interval Upper Limit #NUM!
population sd | 24 |
sample mean | 125 |
sample size | 36 |
confidence level | 0.99 |
standard error of mean | 4 |
z | 2.575829 |
interval half width | 10.30332 |
lower | 114.6967 |
upper | 135.3033 |
formulas
population sd | 24 |
sample mean | 125 |
sample size | 36 |
confidence level | 0.99 |
standard error of mean | =B2/SQRT(B4) |
z | =NORMSINV(B5+(1-B5)/2) |
interval half width | =B8*B7 |
lower | =B3-B9 |
upper | =B3+B9 |
Get Answers For Free
Most questions answered within 1 hours.