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 J2 B D E F H Lower bound of Outcome: Biden's 95% confidence actual share of votes Standard Error interval 625 Upper bound of 95% confidence interval What share of all actual Based on the 95% outcomes were outside of confidence interval, was the the 95% confidence poll wrong? (1=Yes; O=No) interval? 800 717 1185 800 808 710 1657 500 685 871 897 625 611 Biden Share 1 in Latest Poll n 2 0.38 3 0.45 4 0.48 5 6 0.58 7 0.47 8 0.52 9 0.58 10 11 0.47 12 0.46 13 14 15 16 0.42 17 0.49 18 0.42 19 0.39 20 21 0.543 22 23 0.62 24 0.52 25 0.54 26 0.41 27 0.432 28 0.47 29 0.504 30 0.489 31 0.58 32 0.563 33 0.54 34 0.61 35 0.474 36 37 0.47 38 39 40 0.51 41 42 0.41 43 0.4 44 0.39 45 0.487 46 47 48 0.52 49 0.6 50 51 0.527 52 53 54 929 700 770 625 931 886 806 720 600 721 1180 504 855 1440 772 605 625 625 763 908 610 751 If you've listened to news about the 2020 presidential election, you probably heard that "the polls were bad." Were they? Let's find out. The "Data" tab of this workbook contains the President-elect Biden's predicted share of the vote in each state and sample size from the most recent poll for every state in which a high-quality poll was conducted. Your job is to: 1. Collect President-elect Biden's proportion of the actual vote (as of the most recent available data.) 2. Provide a link to the website where you found the actual vote. 3. Enter those proportions into the appropriate column in the spreadsheet. 4. Calculate the upper and lower bounds of the 95% confidence interval for each state poll. 5. Fill in the remaining columns--they're self-explanatory. 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 J2 B D E F H Lower bound of Outcome: Biden's 95% confidence actual share of votes Standard Error interval 625 Upper bound of 95% confidence interval What share of all actual Based on the 95% outcomes were outside of confidence interval, was the the 95% confidence poll wrong? (1=Yes; O=No) interval? 800 717 1185 800 808 710 1657 500 685 871 897 625 611 Biden Share 1 in Latest Poll n 2 0.38 3 0.45 4 0.48 5 6 0.58 7 0.47 8 0.52 9 0.58 10 11 0.47 12 0.46 13 14 15 16 0.42 17 0.49 18 0.42 19 0.39 20 21 0.543 22 23 0.62 24 0.52 25 0.54 26 0.41 27 0.432 28 0.47 29 0.504 30 0.489 31 0.58 32 0.563 33 0.54 34 0.61 35 0.474 36 37 0.47 38 39 40 0.51 41 42 0.41 43 0.4 44 0.39 45 0.487 46 47 48 0.52 49 0.6 50 51 0.527 52 53 54 929 700 770 625 931 886 806 720 600 721 1180 504 855 1440 772 605 625 625 763 908 610 751 If you've listened to news about the 2020 presidential election, you probably heard that "the polls were bad." Were they? Let's find out. The "Data" tab of this workbook contains the President-elect Biden's predicted share of the vote in each state and sample size from the most recent poll for every state in which a high-quality poll was conducted. Your job is to: 1. Collect President-elect Biden's proportion of the actual vote (as of the most recent available data.) 2. Provide a link to the website where you found the actual vote. 3. Enter those proportions into the appropriate column in the spreadsheet. 4. Calculate the upper and lower bounds of the 95% confidence interval for each state poll. 5. Fill in the remaining columns--they're self-explanatory