MPGavg A weighted average of miles per gallon, 60% highway and 40% city MPGcity The estimated miles per gallon for city driving MPGhwy The estimated...
The U.S. government has been interested in pushing auto manufacturers to increase the MPG of their fleet.
- Based on the information above, what proportion of the SUVs are 8 cylinder vehicles (I want the proportion and not the percentage)? I just want the numerical answer. Use 4 decimal places and use the proper rules of rounding.
- Based on the regression results, solve for the predicted MPGavg for 4 cylinder cars. I just want the numerical answer. Use 4 decimal places and use the proper rules of rounding.
- Based on the regression results, solve for the predicted MPGavg for 8 cylinder cars. I just want the numerical answer. Use 4 decimal places and use the proper rules of rounding.
MPGavgA weighted average of miles per gallon, 60% highway and 40% cityMPGcityThe estimated miles per gallon for city drivingMPGhwyThe estimated miles per gallon for city drivingEng SizeThe size of the engine in litersCyl_4Dum A dummy variable coded as one if the engine is 4 cylinders, zero for 6 or 8 cylinder SUVs. Cyl_6Dum A dummy variable coded as one if the engine is 6 cylinders, zero for 4 or 8 cylinder SUVs. Cyl_8Dum A dummy variable coded as one if the engine is 8 cylinders, zero for 4 or 6 cylinder SUVsUnivariate Simple StatisticsColumnNMeanStd DevSumMinimum MaximumMPGavg10021.23003.3751 2123.000014.000029.0000MPGcity100 18.84003.2309 1884.0000 13.000026.0000MPGhwy10025.10003.5434 2510.000017.000033.0000Eng Size1003.20001.2965320.00001.40006.2000Cyl_4Dum1000.45000.500045.00000.00001.0000Cyl_6Dum1000.33000.472633.00000.00001.0000Cyl_8Dum1000.22000.416322.00000.00001.0000The Correlations Matrix is given belowMPGavg MPGcity MPGhwy Eng Size Cyl_4Dum Cyl_6Dum Cyl_8DumMPGavg1.0000MPGcity0.98441.0000MPGhwy0.97110.9349 1.0000Eng Size-0.8437-0.8592 -0.7791.0000Cyl_4Dum0.80000.80790.7554-0.79161.0000Cyl_6Dum -0.2507-0.2495 -0.24310.1105-0.63481.0000Cyl_8Dum-0.6762-0.6869 -0.63130.8253-0.4804-0.37271.0000
Show more