#12 - You are interested in buying a used car, and want to know what you should expect to pay for one. The data file contains 11 variables describing used cars for sale, including the Price. The variables are:

• Price - the selling price of the car in Euros
• Age (in months) at the time of the sale
• KM - the number kilometers
• Fuel Type - Diesel or Petrol
• HP - horsepower
• Automatic - indicator whether the transmission is automatic/manual
• cc - Cylinder Volume in cubic centimeters
• Doors - number of doors
• Gears - number of forward gears
• Quarterly Tax - Quarterly road tax in Euros
• Weight - weight of the can in kilograms.

Download the data file here: https://1drv.ms/u/s!An3_uRLRHjFygaU3nvykvRR7_MXgwg?e=gAMl2D

Fit the multiple regression model using all the variables to explain the Price. To determine if there is a relationship between Price and at least one of the X variables what is the F-statistic that you would use in a formal hypothesis test? Enter your answer to 1 decimal place.

There are three X variables that individually do not make a significant marginal contribution to the model at the = 0.05 level, given all of the other X variables. Identify them, and test whether all three of these should be in the model simultaneously, given everything else that is in the model. Report the partial F-statistic that goes along with that test to 4 decimal places.

What is the result of the test?

• At least one of the three X variables should be in the model at the 5% significance level, given all of the other X's are in the model.
• None of the three X variables should be in the model at the 5% significance level, given all of the other X's are in the model
• All three of the X variables should be in the model at the 5% significance level, given all of the other X's are in the model.