Only do A throught F. Please show all work and create an excel spreadsheet. Thank you!

a regression model to help predict the price he can expect to receive for the cars he owns. He collected the data found in the file Corvettes.xlsx 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, X2 the model year, and X3 the presence (or absence) of a T-top. a. If Roger wants to use a simple linear regression function to estimate the selling price of a car, which X variable do you recommend he use? b. Determine the parameter estimates for the regression function represented by: Y^1=b0+b1X11+b2X2 What is the estimated regression function? Does X2 help to explain the selling price of the cars if X1 is also in the model? What might be the reason for this? c. Set up a binary variable (X3) to indicate whether or not each car in the sample has a T-top. Determine the parameter estimates for the regression function represented by: Y^i=b0+b1X1+b3X3 Does X3 help to explain the selling price of the cars if X1 is also in the model? Explain. d. According to the previous model, on average, how much does a T-top add to the value of a car? e. Determine the parameter estimates for the regression function represented by: Y^i=b0+b1X1i+b2X2+b3X3i What is the estimated regression function? f. Of all the regression functions considered here, which do you recommend Roger use? a regression model to help predict the price he can expect to receive for the cars he owns. He collected the data found in the file Corvettes.xlsx 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, X2 the model year, and X3 the presence (or absence) of a T-top. a. If Roger wants to use a simple linear regression function to estimate the selling price of a car, which X variable do you recommend he use? b. Determine the parameter estimates for the regression function represented by: Y^1=b0+b1X11+b2X2 What is the estimated regression function? Does X2 help to explain the selling price of the cars if X1 is also in the model? What might be the reason for this? c. Set up a binary variable (X3) to indicate whether or not each car in the sample has a T-top. Determine the parameter estimates for the regression function represented by: Y^i=b0+b1X1+b3X3 Does X3 help to explain the selling price of the cars if X1 is also in the model? Explain. d. According to the previous model, on average, how much does a T-top add to the value of a car? e. Determine the parameter estimates for the regression function represented by: Y^i=b0+b1X1i+b2X2+b3X3i What is the estimated regression function? f. Of all the regression functions considered here, which do you recommend Roger use