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 114,858 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 won by Gore in the same county. 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?
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 114,858 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 won by Gore in the same county. 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?
