Purpose: To predict the price of a car using multiple regression in Minitab. Part A 1. Open Minitab. Everyone should be able to access Minitab for free, either through UF Apps (http://apps.ufl.edu) or on any PC computer labs on campus (find locations and hours at: https://labs.at.ufl.edu). You can also download it for a 30-day trial (http://www.minitab.com/en-us/products/minitab/free-trial). 2. Copy and paste the data into Minitab. Open the CSV file cars.csv from the Course webpage. Column A contains the car make, Column B contains the model, columns C and D contain the car's trim and type, column E contains the mileage, column F contains the # of cylinders in the engine, column G contains the liter capacity, column H contains the # of doors, columns I, J and K contain dummy variables for cruise (1 if car has cruise control), sound (1 if the car has upgraded speakers) and leather (1 if car has leather seats) and the last column contains the price of the car. From this CSV file, copy columns A through L and rows 1 through 805 (including the headers) into the top left corner of the Minitab Worksheet as below. C1-T C2-T C3-T C4-T C5 C6 C7 C8 C9 C10 C11 C12 Make Model Trim Type Mileage Cylinder Liter Doors Cruise Sound Leather Price 1 Buick Century Sedan 4D Sedan 8221 6 3.1 4 1 17314.1 Buick Century Sedan 4D Sedan 9135 3.1 0 17542.0 N Buick Century Sedan 4D Sedan 16218.8 3 13196 3.1 0 AA 4 Buick Century Sedan 4D Sedan 16342 3.1 0 0 16336.9 5 Buick Century Sedan 4D Sedan 19832 3.1 0 1 16339.2 AA 6 Buick Century Sedan 4D Sedan 22236 3.1 1 0 15709.1 7 Buick Century Sedan 4D Sedan 22576 3.1 A 1 0 15230.0 8 Buick Century Sedan 4D Sedan 22964 3.1 0 15048.0 O - g Buick Century Sedan 4D Sedan 24021 3.1 AAA 14862.1 10 Buick Century Sedan 4D Sedan 27325 3.1 15295.0 11 Buick Lacrosse CX Sedan 4D Sedan 10237 3.6 0 21335.9 - O AA 0 20538.1 12 Buick Lacrosse CX Sedan 4D Sedan 15066 3.6 13 Buick Lacrosse CX Sedan 4D Sedan 16633 6 3.6 A - 0 20512.13. Fit a multiple regression model using all the predictors available (C1-C1 1). 0 From the menu at the top, select Stat > Regression > Regression > Fit Regression Model. 0 In the eld for Responses, select \"C12 Price.\" 0 In the eld for Continuous predictors, select \"C5 Mileage\grants... | seems\" I spruce-n ] Ali! 4. Write your report. It should be no more than 2 pages and include the following. Your name and UFID. Describe the data set. (2pts) How many samples and variables? What are the meanings of the columns? Copy your results of regression analysis from Minitab. (7pts) Tables for Analysis of Variance, Model Summary, Coefcients are enough. Copy your standardized residual plots from Minitab. (3pts) Write the tted equation with the column names (Mileage, Cylinder, .. .). (2pts) It should be one equation. Interpret the results of the AN OVA test at alpha=0.05. (opts) State your null hypothesis, conclusion (accept/reject) and reason (>0.05). Interpret the results of t tests for Cruise (C9) and Liter(C7) at alpha=0.05. (6pts) State your null hypotheses, conclusions (accept/reject) and reasons (>0.05). Interpret R2. (3pts) It should be about explained variance. Predict the price of a car with cruise control, upgraded speakers, without leather seats, with 10000 mileage, 6 cylinders, 3.6 liters and 4 doors. (3pts) Interpret the coefficients for Doors (C8) and Leather (C11). (4pts) Check Whether the errors (1) are normally distributed and (2) have constant variance based on the residual plots. (4pts) State your conclusions and reasons
