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 14 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: EngineType = o if number of cylinders is less than 10 1 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, CurbWeight, 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 R Square Adjusted R Square Standard Error 0.7581 0.5747 0.5039 5.7825 Observations 29 ANOVA ANOVA Df SS MS F 1084.5500 271.1375 8.1089 Regression Residual 24 802.4845 33.4369 Total 28 1887.0345 Standard Error T Stat P-value Coefficients 101.5132 21.0405 4.8247 0.0001 -0.0065 0.0027 -2.4013 0.0031 Intercept Curb Weight (lb) Engine Type Transmission Type TopSpeed (mph) 2.9392 2.8835 1.0193 0.1554 -4.1952 2.0008 0.0477 -2.0968 2.4113 0.2040 0.0846 0.0240 Referring to the information given above, answer the following question Write the regression equation based on the given results. Problem 1: Model 1 In the following regression models, data provided by Road & Track Sports & GT Cars were used to relate Curb Weight - 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 14 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 0 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 14 mile being the dependent variable. The following table shows the Excel output for this model (refer to this output as model 1)