# Question: The file P02 35 xlsx contains data from a survey of 500

The file P02_35.xlsx contains data from a survey of 500 randomly selected households.

a. In an effort to explain the variation in the size of the monthly home mortgage or rent payment, estimate a multiple regression equation that includes all of the potential household explanatory variables.

b. Using the regression output, determine which of the explanatory variables should be excluded from the regression equation. Justify your choices.

c. Do you obtain substantially different results if you combine First Income and Second Income into a Total Income variable and then use the latter as the only income explanatory variable?

0

a. In an effort to explain the variation in the size of the monthly home mortgage or rent payment, estimate a multiple regression equation that includes all of the potential household explanatory variables.

b. Using the regression output, determine which of the explanatory variables should be excluded from the regression equation. Justify your choices.

c. Do you obtain substantially different results if you combine First Income and Second Income into a Total Income variable and then use the latter as the only income explanatory variable?

0

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

The file P02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. a. Estimate a multiple regression equation to explain the variation in employee salaries at Beta Technologies using all of the ...Continuing Problem 2 with the data in the file P10_04.xlsx, employ stepwise regression to evaluate your conclusions regarding the specification of a regression model to predict the sales of deep-dish pizza by the Original ...Statistician Frank J. Anscombe created a data set to illustrate the importance of doing more than just examining the standard regression output. These data are provided in the file P10_64.xlsx.a. Regress Y1 on X. How well ...The file P11_44.xlsx contains quarterly data on pork sales. Price is in dollars per hundred pounds, quantity sold is in billions of pounds, per capita income is in dollars, U.S. population is in millions, and GDP is in ...Confederate Express is attempting to determine how its monthly shipping costs depend on the number of units shipped during a month. The file P11_53.xlsx contains the number of units shipped and total shipping costs for the ...Post your question