# Question: The file P10 56 xlsx contains some interesting data on the U S

The file P10_56.xlsx contains some interesting data on the U.S. presidential elections from 1880 through 2008. The variable definitions are on the Source sheet. The question is whether the Vote variable can be predicted very well from the other variables.

a. Create pivot tables and/or scatter plots to check whether Vote appears to be related to the other variables. Comment on the results.

b. Run a regression of Vote versus the other variables (not including Year). Do the coefficients go in the direction (positive or negative) you would expect? If you were going to use the regression equation to predict Vote for the 2012 election and you had the relevant data for the explanatory variables for 2012, how accurate do you think your prediction would be?

a. Create pivot tables and/or scatter plots to check whether Vote appears to be related to the other variables. Comment on the results.

b. Run a regression of Vote versus the other variables (not including Year). Do the coefficients go in the direction (positive or negative) you would expect? If you were going to use the regression equation to predict Vote for the 2012 election and you had the relevant data for the explanatory variables for 2012, how accurate do you think your prediction would be?

**View Solution:**## Answer to relevant Questions

We stated in the beginning of the chapter that regression can be used to understand the way the world works. That is, you can look at the regression coefficients (their signs and magnitudes) to see the effects of the ...Suppose the correlation between the average height of parents and the height of their firstborn male child is 0.5. You are also told that:• The average height of all parents is 66 inches. • The standard deviation of the ...The Wilhoit Company has observed that there is a linear relationship between indirect labor expense and direct labor hours. Data for direct labor hours and indirect labor expense for 18 months are given in the file ...The file P02_10.xlsx contains midterm and final exam scores for 96 students in a corporate finance course. Based on a regression equation for the final exam score as a function of the midterm exam score, find a 95% ...Suppose you find the ANOVA table shown in Table 11.2 for a simple linear regression.Table 11.2 ANOVA Table Degrees of Freedom Sum of SquaresExplained ....... 52Unexplained ..... 87Total ......... ...Post your question