AutoSave . OFF George_Confidence_Intervals_for_the_Population_Proportion_Start Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman 16 A ap Wrap Text v General V v Paste BIUV A Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze ormatting as Table Styles Filter Select Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A fx Confidence Interval for the Population Proportion B C D E 1 Confidence Interval for the Population Proportion 2 Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. 3 1-2. In cell B3, find the number of customers who are "Satisfied" from the Data sheet 3. In cell B4, find the sample size of the sample of customers who responded from the Data sheet. 5 4. In cell B5, find the proportion of customers who are satisfied. 6 5. In cell B6, find the standard error of the proportion. 6. To build the confidence interval for the proportion of satisfied customers from the Data sheet, what is the appropriate probability table to use? 8 7. In cell B8, find the value from the appropriate probability table to construct a 90% confidence interval. 9 8. In cell B9, find the margin of error at 90% confidence level. 9. In cell B10, find the upper limit for the population proportion at 90% confidence level. 11 10. In cell B1 1, find the lower limit for the population proportion at 90% confidence level. 12 11. Based on the numbers in cell B9 and B10, we can be 90% confident that 13 12. In cell B13, find the width of the confidence interval at 90% confidence level. 14 13. In cell B14, find the value from the appropriate probability table to construct a 99% confidence interval. 15 14. In cell B15, find the margin of error at 99% confidence level. 16 15. In cell B16, find the upper limit for the population proportion at 99% confidence level. 17 16. In cell B17, find the lower limit for the population proportion at 99% confidence level. 18 17. In cell B18, find the width of the confidence interval at 99% confidence level 19 18. By comparing the width of the confidence interval (CI) at 90% and 99%, what can we conclude about the width of the CI? 20 19. Based on the upper and lower limit values for a 90% confidence level, can the gym's manager be 90% confident that 90% of his customers are satisfied? 21 20. Based on the upper and lower limit values for a 99% confidence level, can the gym's manager be 99% confident that 90% of his customers are satisfied? 22 21. What can the gym manager do to reduce the margin of error at 99% confidence interval? 23 22. In cell B23, find the required sample size to estimate the true proportion of satisfied customers within 3% margin of error, with 99% confidence. 24 34 Instructions Data Questions + Ready - + 100%AutoSave . OFF George_Confidence_Intervals_for_the_Population_Proportion_Start Page Layout Formulas Share Home Tell me Comments Insert Draw Data Review View Times New Roman 12 AA ab Wrap Text v General V v Delete Merge & Center v $ ~ % " Conditional Format Cell Insert Format Find & Analyze Paste DV Sort & BI UV ormatting as Table Styles Filter Select Data Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Check for Updates x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A289 X fx P Q S U V w A B C D E G H M N R 257 256 Satisfied 258 257 Satisfied 259 258 Satisfied 260 259 Satisfied 261 260 Dissatisfied 261 Satisfied 263 262 Satisfied 263 Satisfied 265 264 Dissatisfied 266 265 Satisfied 267 266 Satisfied 268 267 Satisfied 269 268 Satisfied 269 Satisfied 270 Dissatisfied 271 Satisfied 272 Satisfied 273 Satisfied 274 Satisfied 275 Satisfied 276 Dissatisfied 277 Satisfied 278 Satisfied 280 279 Satisfied 281 280 Dissatisfied 282 281 Satisfied 282 Satisfied 284 283 Satisfied 285 284 Satisfied 286 285 Satisfied 287 288 289 Instructions Data Questions + + 100% Ready