Use the StatTool software The data describe information on 1436 different Toyota Corolla cars. Your goals

Use the StatTool software

The data describe information on 1436 different Toyota Corolla cars. Your goals are to explore these data, and to decide on a model that predicts the offer price in Euros (PRICE) for an unlisted car based on information such as KM, HP and Age. The variables in the data are as follow.

There are 39 variables on which observations have been gathered. They are:

Id	Record_ID
Model	Model Description
Price	Offer Price in EUROs
Age_08_04	Age in months as in August 2004
Mfg_Month	Manufacturing month (1-12)
Mfg_Year	Manufacturing Year
KM	Accumulated Kilometers on odometer
Fuel_Type	Fuel Type (Petrol, Diesel, CNG)
HP	Horse Power
Met_Color	Metallic Color? (Yes=1, No=0)
Color	Color (Blue, Red, Grey, Silver, Black, etc.)
Automatic	Automatic ( (Yes=1, No=0)
CC	Cylinder Volume in cubic centimeters
Doors	Number of doors
Cylinders	Number of cylinders
Gears	Number of gear positions
Quarterly_Tax	Quarterly road tax in EUROs
Weight	Weight in Kilograms
Mfr_Guarantee	Within Manufacturer's Guarantee period (Yes=1, No=0)
BOVAG_Guarantee	BOVAG (Dutch dealer network) Guarantee (Yes=1, No=0)
Guarantee_Period	Guarantee period in months
ABS	Anti-Lock Brake System (Yes=1, No=0)
Airbag_1	Driver_Airbag (Yes=1, No=0)
Airbag_2	Passenger Airbag (Yes=1, No=0)
Airco	Airconditioning (Yes=1, No=0)
Automatic_airco	Automatic Airconditioning (Yes=1, No=0)
Boardcomputer	Boardcomputer (Yes=1, No=0)
CD_Player	CD Player (Yes=1, No=0)
Central_Lock	Central Lock (Yes=1, No=0)
Powered_Windows	Powered Windows (Yes=1, No=0)
Power_Steering	Power Steering (Yes=1, No=0)
Radio	Radio (Yes=1, No=0)
Mistlamps	Mistlamps (Yes=1, No=0)
Sport_Model	Sport Model (Yes=1, No=0)
Backseat_Divider	Backseat Divider (Yes=1, No=0)
Metallic_Rim	Metallic Rim (Yes=1, No=0)
Radio_cassette	Radio Cassette (Yes=1, No=0)
Parking_Assistant	Parking assistance system (Yes=1, No=0)
Tow_Bar	Tow Bar (Yes=1, No=0)

Re: The goal of exploring the data

Select 3 variables and examine the Histograms of the data values for them. Describe which of these variables will likely have the most impact on another variable, and why it will do so?
Select 3 pairs of variables, and examine their scatterplots. Describe which of these pairs of variables will most likely have a strong relationship based on these plots, and justify your choice?
Compute the correlation table for all the variables’ values, except for the variable – (Price) offer prices in Euros. Comment on your results.
Describe and justify what you think was the sampling technique used to gather the data for each of three variables in your dataset?
Select 3 variables. What inferences can you make about the true average values for these variables if the data for all cars could have been collected?

Re: The goal of predicting offer prices in Euros(Price)

Use the linear regression technique to identify the ‘best" simple linear regression model for predicting offer prices in Euros? [Be sure to include a couple of the models you tried to determine which one is "best."]
Perform a multiple regression for "Price" with at least 3 predictors, and try to maximize your R-squared value? [ show a couple of the models you tried]

Identify which variables could be dropped from your model above, and not impact the R-squared value in your model by a significant amount?
Discuss whether the coefficients in your model from the previous question are all statistically significant?
Discuss the final result of your multiple regression model. [Your discussion should focus on how reasonable your model seems in theory and for practice].