Problem 1: Model 1 In the following regression models, data…

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 ¼ 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: In the first model, CurbWeight, EngineType, TransmissionType, and TopSpeed were used as independent variables with speed at ¼ mile being the dependent variable. The following table shows the Excel output for this model (refer to this output as model 1). Referring to the information given above, answer the following question Find the estimated speed at ¼ 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.