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. 

Model 1 Model 2 Sometimes variables that were significant in…

Model 1 Model 2 Sometimes variables that were significant in a model may become insignificant in subsequent models. Refer to model 1 and model 2 to see whether we have any independent variables that are significant in model 1 and insignificant in model 2, and which ones are they (if any). If there are variables that are significant in model 1 and then turn insignificant in model 2, what may be the reason?