Question
Roger Gallagher owns a used car lot that deals solely in used Corvettes. He wants to develop a regression model to help predict the price
Roger Gallagher owns a used car lot that deals solely in used Corvettes. He wants to develop a regression model to help predict the price he can expect to receive for the cars he owns. He collected the data found in table below describing the mileage, model year, presence of a T-top, and selling price of a number of cars he has sold in recent months. Let Y represent the selling price,
X1
the mileage (in thousands of miles),
X2
the model year, and
X3
the presence (or absence) of a T-top.
Mileage (in thousands of miles) | Year | T-top | Price (in dollars) |
---|---|---|---|
115 | 1968 | 1 | $14,075 |
95 | 1970 | 0 | $11,200 |
125 | 1972 | 0 | $8,200 |
85 | 1974 | 0 | $15,150 |
77 | 1976 | 1 | $15,825 |
105 | 1978 | 0 | $11,500 |
90 | 1979 | 0 | $13,450 |
71 | 1981 | 1 | $16,700 |
55 | 1983 | 0 | $16,700 |
65 | 1987 | 1 | $19,700 |
45 | 1988 | 0 | $22,500 |
15 | 1988 | 0 | $25,700 |
23 | 1991 | 1 | $32,100 |
(B)
Determine the parameter estimates for the regression function represented by:
i = b0 + b1X1i + b2X2i
What is the estimated regression function? (Use X1 for X1i and X2 forX2i. Round your numerical values to one decimal place.)
i =???
(C) Use the binary variable X3i to indicate whether or not each car in the sample has a T-top ( X3i = 0 indicates a car does not have a T-Top, X3i = 1 indicates a car has a T-Top). Determine the parameter estimates for the regression function represented by:
i = b0 + b1X1i + b3X3i
According to the previous model, on average, how much does a T-top add to the value of a car (in dollars)? (Round your answer to the nearest dollar.)
$=???
Determine the parameter estimates for the regression function represented by:
i = b0 + b1X1i + b2X2i + b3X3i
What is the estimated regression function? (Use X1 for X1i, X2 for X2i, and X3 for X3i. (Round your numerical values to one decimal place.)
i =???
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started