Answer:
"=1-2*(1-NORM.DIST(1.96,0,1,TRUE))"
And we got 95%
"=1-2*(1-NORM.DIST(1.645,0,1,TRUE))"
And we got 90%
"=1-2*(1-NORM.DIST(2.575,0,1,TRUE))"
And we got 99%
Step-by-step explanation:
Previous concepts
A confidence interval is "a range of values that’s likely to include a population value with a certain degree of confidence. It is often expressed a % whereby a population means lies between an upper and lower interval".
The margin of error is the range of values below and above the sample statistic in a confidence interval.
Normal distribution, is a "probability distribution that is symmetric about the mean, showing that data near the mean are more frequent in occurrence than data far from the mean".
Solution to the problem
The confidence interval for the mean is given by the following formula:
(1)
For this case we have the following cases:
And for this case we can find the % of confidence with the following excel code:
"=1-2*(1-NORM.DIST(1.96,0,1,TRUE))"
And we got 95%
For the other case:
And for this case we can find the % of confidence with the following excel code:
"=1-2*(1-NORM.DIST(1.645,0,1,TRUE))"
And we got 90%
For the other case:
And for this case we can find the % of confidence with the following excel code:
"=1-2*(1-NORM.DIST(2.575,0,1,TRUE))"
And we got 99%