Use Minitab Please to answer this question 1 (10 points) Changing Units How does it affect correlation and the LSR Line How does the fuel consumption of a car change as its speed increases The Minitab Express file contains data from the Federal Highway Administration report for fuel efficiency of vehicles In the Minitab Express worksheet, the speed (mph) and the fuel (mpg) are recorded in C1 and C2 respectively Using the following conversions, 1 mile per hour 1 609344 kilometers hour and 1 mile per gallon 0 425143707 kilometers Liter, the speed has been converted to kilometer per hour (km h) in C4 and fuel consumption has been converted to kilometer per liter (km L) in C5 Determine the explanatory and response variable Use Minitab Express to calculate a simple linear regression line equation of speed (mph) and the fuel (US gallon mile) used Include the regression equation and the simple line scatterplot in the document you submit (Use columns C1 and C2 Make sure the explanatory variable is on the horizontal axis ) Use Minitab Express to calculate a simple linear regression line equationof speed (km hr) and the fuel (liters 100km) used Include theregressionequation and the simple linear regression scatterplot in the document you submit (Use columns C4 and C5 Make sure the explanatory variable is on the horizontal axis ) Are there any differences in the plots in b and c Use Minitab Express to compute the Pearson correlation coefficient for both sets of data (columns C1 and C2 together and columns C4 and C5 together) Did correlation change when the units were changed Did the equation of the Least Squares Regression (LSR) line change when the units were changed Graph and interpret the residual plot Only one plot is necessary, use columns C1 and C2 Plot the residuals against the explanatory variable Recall To interpret the residual plots, remember that if there is a pattern in the residual plot, then the LSR line is not appropriate If there is not a pattern, or the residuals look random, then the LSR line is appropriate Looking at the values of the correlation coefficient and the residual plot, do you think it is appropriate to use the LSR line as a model for this data set Explain This is the Minitab Worksheet in CSV so you can easily copy and paste it in excel and upload it also Speed (mph) Fuel Efficiency (MPG) Speed (km h) Fuel Efficiency (km L) 15 24 4 24 14016 10 37350645 20 27 9 32 18688 11 86150943 25 30 5 40 2336 12 96688306 30 31 7 48 28032 13 47705551 35 31 2 56 32704 13 26448366 40 31 64 37376 13 17945492 45 31 6 72 42048 13 43454114 50 32 4 80 4672 13 77465611 55 32 4 88 51392 13 77465611 60 31 4 96 56064 13 3495124 65 29 2 104 60736 12 41419624 70 26 8 112 65408 11 39385135 75 24 8 120 7008 10 54356393

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 07, 2024

Use Minitab Please to answer this question. 1. (10 points) Changing Units - How does it affect correlation and the LSR Line?How does the fuel

Use Minitab Please to answer this question.

1. (10 points) Changing Units - How does it affect correlation and the LSR Line?How does the fuel consumption of a car change as its speed increases? The Minitab Express file contains data from the Federal Highway Administration report* for fuel efficiency of vehicles.

In the Minitab Express worksheet, the speed (mph) and the fuel (mpg) are recorded in C1 and C2 respectively. Using the following conversions, 1 mile per hour = 1.609344 kilometers/hour and 1 mile per gallon = 0.425143707 kilometers/Liter, the speed has been converted to kilometer per hour (km/h) in C4 and fuel consumption has been converted to kilometer per liter (km/L) in C5.

Determine the explanatory and response variable.
Use Minitab Express to calculate a[simple linear regression line]equation of speed (mph) and the fuel (US gallon/mile) used. Include the regression equation and the[simple line scatterplot]in the document you submit. (Use columns C1 and C2. Make sure the explanatory variable is on the horizontal axis.)
Use Minitab Express to calculate a[simple linear regression line] equationof speed (km/hr) and the fuel (liters/100km) used. Include theregressionequation and the[simple linear regression scatterplot]in the document you submit. (Use columns C4 and C5. Make sure the explanatory variable is on the horizontal axis.)
Are there any differences in the plots in b and c?
Use Minitab Express to compute the[Pearson correlation coefficient]for both sets of data (columns C1 and C2 together and columns C4 and C5 together). Did correlation change when the units were changed?
Did the equation of the Least Squares Regression (LSR) line change when the units were changed?
Graph and interpret the[residual plot]. Only one plot is necessary, use columns C1 and C2. Plot the residuals against the explanatory variable. Recall: To interpret the residual plots, remember that if there is a pattern in the residual plot, then the LSR line is not appropriate. If there is not a pattern, or the residuals look random, then the LSR line is appropriate.
Looking at the values of the correlation coefficient and the residual plot, do you think it is appropriate to use the LSR line as a model for this data set? Explain.

This is the Minitab Worksheet in CSV so you can easily copy and paste it in excel and upload it also.

Speed (mph)	Fuel Efficiency (MPG)	Speed (km/h)	Fuel Efficiency (km/L)
15	24.4		24.14016	10.37350645
20	27.9		32.18688	11.86150943
25	30.5		40.2336	12.96688306
30	31.7		48.28032	13.47705551
35	31.2		56.32704	13.26448366
40	31		64.37376	13.17945492
45	31.6		72.42048	13.43454114
50	32.4		80.4672	13.77465611
55	32.4		88.51392	13.77465611
60	31.4		96.56064	13.3495124
65	29.2		104.60736	12.41419624
70	26.8		112.65408	11.39385135
75	24.8		120.7008	10.54356393