Miles Filtration, Inc. provides maintenance services for water filtration systems throughout Southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate service time and the service cost, Johnson’s managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table: Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the repairperson, and the type of repair. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Please show the work in Excel.
Miles Filtration, Inc. provides maintenance services for water filtration systems throughout Southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate service time and the service cost, Johnson’s managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table:
Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the repairperson, and the type of repair.
What are the interpretations of the estimated regression parameters?
What does the coefficient of determination tell you about this model?
Please show the work in Excel.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
