Home / Answered Questions / WPC 300 / wpc-300-assignment-6-linear-regression-carsdata-jmp-feb-2021-q-168

# (Solved): WPC 300 : Assignment 6: Linear Regression-CarsData.jmp feb-2021...

Assignment 6: Linear Regression

Started: Feb

Quiz Instructions

Actions

• Change the file name to: YourFirstName_YourLastName_Assignment6.jmp
• You must use JMP to answer the following multiple-choice questions.
• Note: When you are asked to submit a screen capture, you need to make sure that your name is part of the capture.

Question 1        2.5 pts

You have been asked to test if 'city mileage' of a car can be predicted based on the 'Fuel Tank capacity'. Which of the following statements is correct?

• Dependent variable ‘Fuel Tank Capacity’ is negatively correlated with independent variable ‘City Mileage of Car’
• The test shows that the variables are significantly correlated. Dependent variable ‘City mileage car’ is predicted as City Mileage (MPG) = 45.587166 - 1.3934743*Fuel Tank Capacity
• The test shows that both variables are correlated. The dependent variable ‘Fuel Tank Capacity’ is predicted as Fuel Tank Capacity = 45.587166 + 1.3934743*City Mileage of Car.
• The test shows that both variables are not correlated. Dependent variable City mileage car is predicted as City Mileage (MPG) = 45.587166 + 1.3934743*Fuel Tank Capacity

Question 2         2.5 pts

What is the coefficient of determination between 'City Mileage' and 'Weight'? [Save the script to the data file]

• 47.05
• 0.71
• -0.008
• 0.66

Question 3        2.5 pts

The team wants to find out if there are any other variables that are significantly correlated, with a correlation coefficient greater than +0.8 or less than -0.8. Execute an appropriate analysis to answer this question. Which of the following combinations of variables satisfy this condition? [Save the script to the data file]

• Luggage Capacity and weight
• Fuel Tank Capacity & Weight
• Weight & Maximum Horsepower
• Maximum Horsepower & Engine Size

Question 4       2.5 pts

Use the least square method to develop a linear model to predict the city mileage of a car using all other variables in the data file as independent variables, except ‘Model’ & ‘Manufacturer’. Remove the insignificant parameters from the model one by one by checking the log(worth) of each parameter and removing the least important parameter first from the model. Which of the following variables remain significant in the final model? [Save Script to the datafile]

• Maximum Horsepower & Fuel Tank Capacity
• Vehicle category & Weight
• Luggage capacity & Weight
• Rear seat room & Weight

Question 5        2.5 pts

What is the coefficient of determination of model equation obtained from Question 4?

• 0.43
• 0.64
• 0.78
• 0.80

Question 6           2.5 pts

The team also asked you to check for any multi-collinearity effects in your model obtained from Question 4. After testing for any multi-collinearity effects (using VIF), what did you find out?

• ‘Passenger capacity’ and ‘Length’ variables show multi-collinearity effects in the model
• ‘Passenger capacity’ and ‘Weight’ variables show multi-collinearity effects in the model
• ‘Fuel Tank Capacity’, ‘Width’ and ‘Weight’ variables show multi-collinearity effects in the model
• ‘Vehicle Category’ and ‘Engine Size’ variables show multi-collinearity effects in the model

Question 7        2.5 pts

If you discovered multi-collinearity effects in the model, remove the variables in question one at a time (starting from the highest VIF) from the model and then stop when you don’t need to remove any further variable(s) from the model based on accepted VIF and p-values. After this process, submit the screenshot of the ‘Effect Summary’ of the final model.

Question 8            2.5 pts

Based on the model in question 7,  what are the strongest and weakest variables in predicting the city mileage of a car?

• Passenger Capacity (strongest) and Weight (weakest)
• Vehicle Category (strongest) and Passenger Capacity (weakest)
• Weight (strongest) and ‘Length’ (weakest)
• Fuel Tank Capacity (strongest) and Passenger Capacity (weakest)

Question 9          2.5 pts

What is the model equation for the final model in Question 7 to predict City mileage of a car? [Save script] Submit a screenshot.

Question 10       2.5 pts

Submit the JMP data file with saved script for all the analysis to answer questions from this assignment.

We have an Answer from Expert