Question

NARRBEGIN: SA_100_102
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.
Summary measures
Multiple R0.8391
R-Square0.7041
Adj R-Square0.6783
StErr of Estimate148.828
ANOVA Table




SourcedfSSMSFp-value
Explained21212039606019.727.36010
Unexplained23509444.922149.8

Regression coefficients



CoefficientStd Errt-valuep-value
Constant-1242.99331.204-3.75290.001
Age of Item75.01710.657.04590
Number of Bidders13.97310.441.3380.194
NARREND
(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.

Answer

This answer is hidden. It contains 438 characters.