A maintenance service would like to predict the service time for maintenance requests. They have gat

/in /by

A maintenance service would like to predict the service time for maintenance requests. They have gathered some data from the last 10 requests: repair time, months since last service, type of repair, and repair person. Assign the needed dummy variables to this data and develop a multiple regression model to predict the repair time. Drop any unneeded predictive variable from the model and provide the final equation. Write a couple of sentences interpreting the result and indicate the impact of the predictive variables you used.

Repair Time in Hours Months Since Last Service Type of Repair Repairperson

2.9 2 Electrical Donna Newton

3.0 6 Mechanical Donna Newton

4.8 8 Electrical Bob Jones

1.8 3 Mechanical Donna Newton

2.9 2 Electrical Donna Newton

4.9 7 Electrical Bob Jones

4.2 9 Mechanical Bob Jones

4.8 8 Mechanical Bob Jones

4.4 4 Electrical Bob Jones

4.5 6 Electrical Donna Newton

Please help!! Thank you! Has to be completed in excel.