Liked

Problem 1: Model 1 In the following regression models, data provided by Road & Track Sports & GT Cars were used to relate CurbWeight - curb weight (lb.), engine type, transmission type, ZeroTo60 - time to go from 0 to 60 mph (seconds), TopSpeed- highestspeed (mph), and HorsePower -horse power to speed at /4 mile (mph) for 29 sports and GT cars. To incorporate engine type and transmission type into the regression model, the following dummy variables were defined: Engine Type = $ 0 if number of cylinders is less than 10 1 if number of cylinders is greater than or equal to 10 Transmission Type = S 0 if transmission is automatic I if transmission is manual In the first model, Curb Weight, EngineType, TransmissionType, and TopSpeed were used as independent variables with speed at 44 mile being the dependent variable. The following table shows the Excel output for this model (refer to this output as model 1). Regression Statistics Multiple R 0.7581 Square 0.5747 Adjusted R Square 0.5039 Standard Error 5.7825 Observations 29 ANOVA Regression Statistics Multiple R 0.7581 R Square 0.5747 Adjusted R Square 0.5039 Standard Error 5.7825 Observations 29 ANOVA Df SS MS F 4 1084.5500 Regression Residual 271.1375 8.1089 24 802.4845 33.4369 Total 28 1887.0345 Standard Error T Stat Coefficients 101.5132 21.0405 4.8247 -2.4013 P-value 0.0001 0.0031 -0.0065 0.0027 Intercept Curb Weight (lb) Engine Type Transmission Type TopSpeed (mph) 2.9392 2.8835 1.0193 0.1554 0.0477 -4.1952 2.0008 -2.0968 0.2040 0.0846 2.4113 0.0240 Referring to the information given above, answer the following question Find the estimated speed at %4 mile for the 1997 McLaren F1 which is advertised as having a CurbWeight of 2840 pounds, 12 cylinder engine, 6- speed Manual transmission, and a highest speed of 231 mph. Problem 1: Model 1 In the following regression models, data provided by Road & Track Sports & GT Cars were used to relate CurbWeight - curb weight (lb.), engine type, transmission type, ZeroTo60 - time to go from 0 to 60 mph (seconds), TopSpeed- highestspeed (mph), and HorsePower -horse power to speed at %4 mile (mph) for 29 sports and GT cars. To incorporate engine type and transmission type into the regression model, the following dummy variables were defined: Engine Type - 0 if number of cylinders is less than 10 1 if number of cylinders is greater than or equal to 10 Transmission Type O if transmission is automatic 1 if transmission is manual In the first model, CurbWeight, EngineType, TransmissionType, and TopSpeed were used as independent variables with speed at y mile being the dependent variable. The following table shows the Excel output for this model (refer to this output as model 1). Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.7581 0.5747 0.5039 5.7825 29