Please help with question 2 a-e

2. Johnson Filtration, Inc., provides maintenance service for water-filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water-filtration systems. To estimate the service time and the service cost, Johnson's managers want to predict the repair time necessary for each maintenance request. Repair time (y, in hours) is believed to be related to the number of months since the last maintenance service, the type of repair problem (electrical or mechanical) and repairperson (Bob Jones or Dave Newton). Please use the following Minitab output to help you answer the questions. A regression analysis was conducted to predict the repair time (y, in hours), given the number of months since the last maintenance service (xi), the type of repair (x2), and the repairperson (x3) who performed the service. Define a dummy variable x2 for type of repair, X2 = {t if a mechanical repair O if an electrical repair and define a dummy variable xz for repair person, x2 = { 1 if Bob Jones performed the service O if Dave Newton performed the service Regression Analysis: Repair time versus x1, x2, x3 Regression Equation Repair time 2.543 + 0.1644 x1 - 0.507 x2 + 1.222 x3 Coefficients Term Coef SE Coef T-Value P-Value VIF Constant 2.543 0.315 8.07 0.000 X1 0.1644 0.0710 2.32 0.038 1.88 x2 -0.507 0.261 -1.94 0.075 1.09 X3 1.222 0.337 3.63 0.003 1.81 Model Summary S R-sq R-sq(adj) 0.508047 79.62% 74.91% Analysis of Variance R-sq(pred) 60.14% DF 3 1 Source Regression x1 X2 X3 Error Lack-of-Fit 1 1 Adj SS Adj MS F-Value P-value 13.1069 4.3690 16.93 0.000 1.3849 1.3849 5.37 0.038 0.9699 0.9699 3.76 0.075 3.4035 3.4035 13.19 0.003 3.3555 0.2581 2.7055 0.3006 1.85 0.290 13 9 Pure Error 4 0.6500 0.1625 Total 16 16.4624 a) Predict the repair time for a service for an electrical problem performed by Bob Jones with 9 months since the last maintenance occurred. b) Interpret the coefficients of the type of repair. c) Interpret the coefficients of the repairperson. d) At the 0.05 level of significance, test whether the estimated regression equation represents a significant relationship between the independent variables and the dependent variable. Make sure to show all the steps. (Hint: This is an overall significant test] e) Is the repair type significantly related to the repair time? Use a = 0.05, and make sure to show all the steps