In: Statistics and Probability
In a survey of 1,000 adults in a country, 722 said that they had eaten fast food at least once in the past month. Create a 95% confidence interval for the population proportion of adults who ate fast food at least once in the past month. Use Excel to create the confidence interval, rounding to four decimal places.
In a survey of 1,000 adults in a country, 722 said that they had eaten fast food at least once in the past month. Create a 95% confidence interval for the population proportion of adults who ate fast food at least once in the past month. Use Excel to create the confidence interval, rounding to four decimal places.
95% confidence interval for the population proportion = (0.6942, 0.7498)
Confidence Interval Estimate for the Proportion |
|
Data |
|
Sample Size |
1000 |
Number of Successes |
722 |
Confidence Level |
95% |
Intermediate Calculations |
|
Sample Proportion |
0.722 |
Z Value |
-1.9600 |
Standard Error of the Proportion |
0.0142 |
Interval Half Width |
0.0278 |
Confidence Interval |
|
Interval Lower Limit |
0.6942 |
Interval Upper Limit |
0.7498 |
Confidence Interval Estimate for the Proportion |
|
Data |
|
Sample Size |
1000 |
Number of Successes |
722 |
Confidence Level |
0.95 |
Intermediate Calculations |
|
Sample Proportion |
=B5/B4 |
Z Value |
=NORM.S.INV((1-B6)/2) |
Standard Error of the Proportion |
=SQRT(B9*(1-B9)/B4) |
Interval Half Width |
=ABS(B10*B11) |
Confidence Interval |
|
Interval Lower Limit |
=B9-B12 |
Interval Upper Limit |
=B9+B12 |