I need help with this assignment! I have some others I will need assistance with as well.

On the tab labeled "Data", I have provided the calendar year 2000 Presidential voting results from Florida which are associated with Case 9.2 on Pages 481. Carefully read the case in the textbook and then review the data to familiarize yourself with the given information. On the "Case Update" tab, there are five questions. After performing all necessary work in Excel, please respond to each question. All written results should be included on the Case Update tab. Each question is worth 16 points: 8 points for the correct mechanical work within Excel and 8 points for a clear, concise, grammatically correct response to the associated question. Your responses should be typed in unbolded black font right after the statement of the question. Remember, cases are individual work. Good luck and as always...HAVE FUN! COUNTY Liberty Lafayette Glades Union Hamilton Franklin Dixie Calhoun Gilchrist Gulf Madison Hardee Taylor Holmes De Soto Washington Hendry Baker Wakulla Bradford Okeechobee Suwannee Levy Jackson Walton Columbia Sumtter Nassau Putnam Highlands Indian River Santa Rosa Citrus Clay Bay St. Johns Martin Charlotte Okaloosa Lake Collier Marion Manatee Escambia Seminole Sarasota Polk Lee Brevard Duval Hillsborough COUNTY Jefferson Gadsden Flagler Monroe Osceola Hernando St. Lucie Alachua Leon Pasco Volusia Orange Pinellas Palm Beach Broward Dade Gore 1011 788 1441 1407 1722 2046 1826 2155 1910 2389 3011 2341 2647 2154 3322 2796 3239 2392 3835 3072 4588 4084 5403 6868 5637 7047 9634 6952 12091 14167 19768 12795 25501 14630 18850 19482 26619 29641 16924 36555 29905 44665 49169 40958 58888 72854 74977 73560 97318 107680 169529 Bush 2478 4750 12608 16059 26212 30646 34705 34062 39053 68582 82214 134476 184884 152846 177279 289456 Votes for: Bush 1361 1696 1804 2322 2164 2444 2679 2837 3200 3564 3083 3746 4015 4958 4265 4938 4734 5601 4499 5431 5085 8041 6806 9183 12761 10946 12621 16505 13493 20260 28653 36482 29744 41745 38637 39497 33864 35419 52043 49963 60426 55555 57948 73029 75293 83400 90101 106141 115001 152020 180713 Gore 3014 9556 13981 16843 28081 32446 41303 47100 61130 69264 96163 140151 200312 268905 385618 328207 Buchanan 39 10 9 29 23 33 29 90 29 71 29 30 27 76 36 88 22 73 46 65 43 108 67 102 120 89 114 90 147 127 105 311 270 186 248 229 108 182 267 289 122 563 272 504 194 305 538 305 570 650 845 Buchanan 29 39 83 47 145 242 124 262 282 570 396 446 1010 3407 789 561 Total Votes 2411 2494 3254 3758 3909 4523 4534 5082 5139 6024 6123 6117 6689 7188 7623 7822 7995 8066 8380 8568 9716 12233 12276 16153 18518 18082 22369 23547 25731 34554 48526 49588 55515 56561 57735 59208 60591 65242 69234 86807 90453 100783 107389 114491 134375 156559 165616 180006 212889 260350 351087 Total Votes 5521 14345 26672 32949 54438 63334 76132 81424 100465 138416 178773 275073 386206 425158 563686 618224 Counties won by Bush Counties won by Gore Question 1 (16 Points): On the Data tab, you will find the results listed by the counties each candidate won during the election (Bush in red and Gore in blue). Considering only the counties won by Bush, on a new tab labeled "Bush Scatter", build a scatterplot with Gore totals as the independent variable and Bush totals as the dependent variable. What is the associated regression equation and goodness of fit measure? Question 2 (16 Points): On the Data tab, you will find the results listed by the counties each candidate won during the election (Bush in red and Gore in blue). Considering only the counties won by Gore, on a new tab labeled "Gore Scatter", build a scatterplot with Bush totals as the independent variable and Gore totals as the dependent variable. What is the associated regression equation and goodness of fit measure? Question 3 (16 Points): Bush won Brevard County with 115,001 votes. Using the results in Question 1 above, estimate the total number of votes President Bush should have received given the actual number of votes for Gore. What is the residual as compared to the actual number of votes won by Bush? Question 4 (16 Points): Now we want to estimate the number of votes Buchanan should have received given the votes received by both Bush and Gore in the counties won by each candidate. On a new tab labeled "Bush Multiple" use both the Bush and Gore totals from the counties won by Bush as independent variables along with the asociated Buchanan totals as the dependent variable and develop the regression equation. On a new tab labeled "Gore Multiple" use both the Bush and Gore totals from the counties won by Gore as independent variables along with the asociated Buchanan totals as the dependent variable and develop a second regression equation. After completing these analyses, which data, either the counties won by Bush or the counties won by Gore, best estimate the number of votes expected for Buchanan. Clearly state the reasoning behind your choice of data selection. Question 5 (16 Points): Based on the best model you found in Question 4, refer back to the Data tab and note that each candidate has a row where the entries are in white font. If the best model you found in Question 4 was based off the counties won by Bush, estimate the number of votes Buchanan should have received in Okeechobee County based on the votes received by Bush and Gore. If the best model you found in Question 4 was based off the counties won by Gore, estimate the number of votes Buchanan should have expected in Palm Beach County based on the votes received by Bush and Gore. What isthe residual value in the predicted number of votes as compared to the actual number of votes received by Buchanan