BOsei836 x AutoSave @ off) Activity 9 Fall 2020 (1) Search (Alt+Q) Comments Review View Help Picture Format File Home Insert Draw Page Layout Formulas Data Insert ~ O - A A Number Delete Sort & Find & Analyze Conditional Format as Cell Data ~ % 9 08 98 Styles ~ Format ~ Filter ~ Select aste BIU- H - MA- Formatting Table Editing Analysis Cells Styles Number Clipboard Font Alignment Undo R S Picture 2 vi XVfx P M N O Q D E G H Data 79.3 77.7 75.5 75.5 74.7 IN 76.6 73.7 74.8 73.3 77.4 73.0 74.5 75.0 75.4 74.9 74.1 17.2 80.7 78.2 73.5 73.7 The Hawaii Island Chamber of Commerce collects ocean temperatures data to help promote tourism for local 76.4 74.7 79.7 5 73.1 74.7 76.5 75.2 businesses. The following data list daily ocean temperatures for the past 125 days. 6 75.7 73.8 72.4 74.6 74.6 74.6 77.3 1. Construct and interpret a 95% confidence interval to estimate the average ocean temperature for Hawaii. 7 75.0 74.5 72.8 74.0 74.8 75.5 71.0 75.9 73.1 73.6 8 77.8 75.9 74.7 76.7 77.7 2. What is the margin of error with 95% confidence level? 73.3 77.0 75.8 77.7 75.0 10 17.7 74.2 76.6 73.8 3. Construct and interpret a 90% confidence interval to estimate the average ocean temperature for Hawaii. 75.3 80.5 11 77.2 72.1 76.4 78.4 75.3 75.1 77.5 72.8 12 77.0 77.5 4. What is the margin of error with 90% confidence level? 75.3 75.6 77.4 77.0 75.4 83.2 13 78.2 78.8 5. How does decreasing the confidence level change the margin of error? 14 75.8 74.4 76.7 17.4 75.9 75.6 75.5 BO.5 78.7 80.1 15 16.2 16 76.9 17.7 78.6 73.9 76.0 76.8 71.4 73.4 17 75.7 73.0 78.8 77.6 75.9 18 78.2 76.1 78.3 74.8 75.6 74.6 74.4 19 76.0 73.8 73.1 81.1 20 754 73.9 73.2 78.1 76.6 77.1 21 76.2 76.0 75.1 78.9 76.0 22 Problem 1 Problem 2 + Average 76.2 Count: 5 Sum: 380.8 Ready Accessibility: Investigate HOLD - B W N X S P 64'F Partly sunnyX AutoSave on) Activity 9 Fall 2020 (1) - Protected View Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing P2 v I X V fx A B C D G H K L M N 2 Data 25 A W 270 The U.S. Census Bureau would like to estimate the average annual contributions to charity by the members 60 of Generation Y (people born in the United States in the years 1981 through 1991). The following data shows 750 the annual contributions to charity for a random sample of 18 individuals in this age group. 415 1. Construct and interpret a 95% confidence interval to estimate the average annual contributions to charity Co 595 for this age group. 9 390 2. What is the margin of error with 95% confidence level? 10 450 11 400 3. Construct and interpret a 99% confidence interval to estimate the average annual contributions to charity for this age group. 12 160 13 192 4. What is the margin of error with 99% confidence level? 14 155 5. How does increasing the confidence level change the margin of error? 15 200 16 460 650 18 510 9 330 225 Problem 1 Problem 2 ady W N 64-F Partly sunny hp