35. Refer to the Lincolnville School District bus data. First, add a variable to change the typeof engine (diesel or gasoline) to a qualitative variable. If the engine type is diesel, thenset the qualitative variable to 0. If the engine type is gasoline, then set the qualitativevariable to 1. Develop a regression equation using statistical software with maintenancecost as the dependent variable and age, odometer miles, miles since last maintenance,and engine type as the independent variables.a. Develop a correlation matrix. Which independent variables have strong or weak correlationswith the dependent variable? Do you see any problems with multicollinearity?b. Use a statistical software package to determine the multiple regression equation.How did you select the variables to include in the equation? How did you use theinformationfrom the correlation analysis? Show that your regression equation showsa significant relationship. Write out the regression equation and interpret its practicalapplication. Report and interpret the R-square.c. Develop a histogram or a stem-and-leaf display of the residuals from the final regressionequation developed in part (f). Is it reasonable to conclude that the normalityassumption has been met?d. Plot the residuals against the fitted values from the final regression equation developedin part (f) against the fitted values of Y. Plot the residuals on the vertical axis andthe fitted values on the horizontal axis.

Please Expalin the answer step by step in excel use.

https://docs.google.com/spreadsheets/d/1mPLir8Ch4ARq598DTt0eMrWtsgpwuAYxMdqF1itHI5c/edit?usp=sharing