Question
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,
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started