Question

For each part of the question what steps do I need to take in minitab to find this answer?

Months Since Type of Repair Time (hours) Last ServiceRepair Repairperson electrical Dave Newton mechanical Dave Newtorn electricalBob Jones mechanical Dave Newton electrical Dave Newton 4.8 4.9 7 electrical Bob Jones d Minitab output if you used mechanical Bob Jonesi mechanical Bob Jones electrical Bob Jones 4.2 4.8 4.4 ltration, Inc. provides maintenance service for water-filtration systems ohnson Filtration. throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water-filtration systems. To estimate the service time a Johnson's managers want to predict the repair time necessary for each maintenance request. Repair time 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. Please download the dataset Repair.xisx from Canvas and use Minitab to help you answer the following questions nd the service cost, Develop the estimated regression equation to predict the repair time (y). given the number of months since the last maintenance service (x1). a) b) Develop the estimated regression equation to predict the repair time (). given the number of months since the last maintenance service (x1), the type of repair (x2).[For dummy variable xz. let Type = l if an electrical repair. Type-0 if a mechanical repair.] Does the equation that you developed in part (b) provide a good fit for the observed data? Explain. e) d) Develop the estimated regression equation to predict the repair time (y). given the number of months since the last maintenance service (x1). the type of repair (x2), and the repairperson (xs) who performed the service. Hint: For dummy variable x2. let Type-I if an electrical repair, For dummy variable x3, let Person - I if Dave Newton performed the service, Type 0 ifa mechanical repair. Person = 0 if Bob Jones performed the service.] e Interpret the coefficients of the type of repair in part (d). 0 Interpret the coefficients of the repairperson in part (d) g) At the 0.05 level of significance, test whether the estimated regression equation developed in part (d) represents a significant relationship between the independent variables and the dependent variable. Make sure to show all the steps. Is the repairperson who performed the service significantly related to the repair time in part (d)? Use α = 0.05, and make sure to show all the steps. h)