Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

{1} Sales of Toyota Corolla Cars The file ToyotaCorollaxls contains data on used cars {Toyota Corollas) on sale during late summer of 2DD4 in The

image text in transcribed
{1} Sales of Toyota Corolla Cars The file ToyotaCorollaxls contains data on used cars {Toyota Corollas) on sale during late summer of 2DD4 in The Netherlands. It has 143E records containing details on 33 attributes, including F'rice, Age, Kilometers, HF', and other specifications. The goal will be to estimate the price of a used Toyota Corolla based on its specifications. Let Y represent the price, X1 the age f\"age_Dt3_D4), X2 Guarantee period, and X3 the automatic {yes=1, noz}. {1) If he wants to use a simple linear regression model to estimate the selling price of a car, which X variable do you recommend he use? (2) Develop a multiple linear regression model by using X1 and X2. Report coefcients of X1 and X2. Does X2 help to explain the selling price of the cars? {3} Develop a multiple linear regression model by using X1 and X3, and report their coefficients. Does X3 help to explain the selling price of the cars? How much does an automatic option add to the value of a car? (4} Develop a multiple linear regression model with X1, X2, and X3 and construct a polynomial term if necessary. Does your polynomial term help to explain the selling price of the cars? Also, provide the scatter plot between a dependent variable and a polynomial term you created. (5) Develop a multiple linear regression model with X1, X2, and X3 and construct an interaction term if necessary. Does your interaction term help to explain the selling price of the cars? {E} Consider the pvalues for each Bi in this model {question (5)). Do these values indicate that any of the independent variables should be dropped form the model? Provide your FINAL model as an equation {e.g., D.34+.32Color D.12Price mm). [7} Interpret the values of adjusted R2 for each model. Which model do you recommend Roger use? From the question (El), create dummy variables for the categorical variables {e.g., Fuel_Type) and split the data into training {60%) and validation (40%}. (8) Develop a multiple regression model with all variables you have and report your model as an equation. Also, please compare adjusted Ft square values between two models (one from (E) and the other from {8}) models. Then, Which model do you recommend Roger use? Justify your

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning For Business Analytics

Authors: Galit Shmueli, Peter C. Bruce, Amit V. Deokar, Nitin R. Patel

1st Edition

1119828791, 9781119828792

More Books

Students also viewed these Mathematics questions

Question

2.1 Explain how employment-related issues are governed in Canada.

Answered: 1 week ago

Question

2.3 Describe the requirements for reasonable accommodation.

Answered: 1 week ago