A new online auction site specializes in selling automotive parts for classic cars. The founder of the company believes that the price received for a particular item increases with its age (i.e., the age of the car on which the item can be used in years) and with the number of bidders. The Excel multiple regression output is shown below.
-(A) Estimate a multiple regression model for the data.
(B) Which of the variables in this model have regression coefficients that are statistically different from 0 at the 5% significance level?
(C) Given your findings in (B), which variables, if any, would you choose to remove from the model estimated in (A)? Explain your decision.

Question

A new online auction site specializes in selling automotive parts for classic cars. The founder of the company believes that the price received for a particular item increases with its age (i.e., the age of the car on which the item can be used in years) and with the number of bidders. The Excel multiple regression output is shown below. 
-(A) Estimate a multiple regression model for the data.
(B) Which of the variables in this model have regression coefficients that are statistically different from 0 at the 5% significance level?
(C) Given your findings in (B), which variables, if any, would you choose to remove from the model estimated in (A)? Explain your decision.

Quizplus · Accepted Answer

The Answer of A new online auction site specializes in selling automotive parts for classic cars. The founder of the company believes that the price received for a particular item increases with its age (i.e., the age of the car on which the item can be used in years) and with the number of bidders. The Excel multiple regression output is shown below. 
-(A) Estimate a multiple regression model for the data.
(B) Which of the variables in this model have regression coefficients that are statistically different from 0 at the 5% significance level?
(C) Given your findings in (B), which variables, if any, would you choose to remove from the model estimated in (A)? Explain your decision.

A New Online Auction Site Specializes in Selling Automotive Parts