Chapter 9 Case 9.2
Research-Expert
c3_ch9_9-1.3.xlsxInstructions
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!
Data
| Votes for: | ||||
| COUNTY | Gore | Bush | Buchanan | Total Votes |
| Liberty | 1011 | 1361 | 39 | 2411 |
| Lafayette | 788 | 1696 | 10 | 2494 |
| Glades | 1441 | 1804 | 9 | 3254 |
| Union | 1407 | 2322 | 29 | 3758 |
| Hamilton | 1722 | 2164 | 23 | 3909 |
| Franklin | 2046 | 2444 | 33 | 4523 |
| Dixie | 1826 | 2679 | 29 | 4534 |
| Calhoun | 2155 | 2837 | 90 | 5082 |
| Gilchrist | 1910 | 3200 | 29 | 5139 |
| Gulf | 2389 | 3564 | 71 | 6024 |
| Madison | 3011 | 3083 | 29 | 6123 |
| Hardee | 2341 | 3746 | 30 | 6117 |
| Taylor | 2647 | 4015 | 27 | 6689 |
| Holmes | 2154 | 4958 | 76 | 7188 |
| De Soto | 3322 | 4265 | 36 | 7623 |
| Washington | 2796 | 4938 | 88 | 7822 |
| Hendry | 3239 | 4734 | 22 | 7995 |
| Baker | 2392 | 5601 | 73 | 8066 |
| Wakulla | 3835 | 4499 | 46 | 8380 |
| Bradford | 3072 | 5431 | 65 | 8568 |
| Okeechobee | 4588 | 5085 | 43 | 9716 |
| Suwannee | 4084 | 8041 | 108 | 12233 |
| Levy | 5403 | 6806 | 67 | 12276 |
| Jackson | 6868 | 9183 | 102 | 16153 |
| Walton | 5637 | 12761 | 120 | 18518 |
| Columbia | 7047 | 10946 | 89 | 18082 |
| Sumtter | 9634 | 12621 | 114 | 22369 |
| Nassau | 6952 | 16505 | 90 | 23547 |
| Putnam | 12091 | 13493 | 147 | 25731 |
| Highlands | 14167 | 20260 | 127 | 34554 |
| Indian River | 19768 | 28653 | 105 | 48526 |
| Santa Rosa | 12795 | 36482 | 311 | 49588 |
| Citrus | 25501 | 29744 | 270 | 55515 |
| Clay | 14630 | 41745 | 186 | 56561 |
| Bay | 18850 | 38637 | 248 | 57735 |
| St. Johns | 19482 | 39497 | 229 | 59208 |
| Martin | 26619 | 33864 | 108 | 60591 |
| Charlotte | 29641 | 35419 | 182 | 65242 |
| Okaloosa | 16924 | 52043 | 267 | 69234 |
| Lake | 36555 | 49963 | 289 | 86807 |
| Collier | 29905 | 60426 | 122 | 90453 |
| Marion | 44665 | 55555 | 563 | 100783 |
| Manatee | 49169 | 57948 | 272 | 107389 |
| Escambia | 40958 | 73029 | 504 | 114491 |
| Seminole | 58888 | 75293 | 194 | 134375 |
| Sarasota | 72854 | 83400 | 305 | 156559 |
| Polk | 74977 | 90101 | 538 | 165616 |
| Lee | 73560 | 106141 | 305 | 180006 |
| Brevard | 97318 | 115001 | 570 | 212889 |
| Duval | 107680 | 152020 | 650 | 260350 |
| Hillsborough | 169529 | 180713 | 845 | 351087 |
| COUNTY | Bush | Gore | Buchanan | Total Votes |
| Jefferson | 2478 | 3014 | 29 | 5521 |
| Gadsden | 4750 | 9556 | 39 | 14345 |
| Flagler | 12608 | 13981 | 83 | 26672 |
| Monroe | 16059 | 16843 | 47 | 32949 |
| Osceola | 26212 | 28081 | 145 | 54438 |
| Hernando | 30646 | 32446 | 242 | 63334 |
| St. Lucie | 34705 | 41303 | 124 | 76132 |
| Alachua | 34062 | 47100 | 262 | 81424 |
| Leon | 39053 | 61130 | 282 | 100465 |
| Pasco | 68582 | 69264 | 570 | 138416 |
| Volusia | 82214 | 96163 | 396 | 178773 |
| Orange | 134476 | 140151 | 446 | 275073 |
| Pinellas | 184884 | 200312 | 1010 | 386206 |
| Palm Beach | 152846 | 268905 | 3407 | 425158 |
| Broward | 177279 | 385618 | 789 | 563686 |
| Dade | 289456 | 328207 | 561 | 618224 |
Counties won by Bush Counties won by Gore
Case Update
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?
