Answered You can hire a professional tutor to get the answer.

QUESTION

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.

  1. 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.
  2. 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.
  3. 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
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question