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

 
   

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.  

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.