(c) Create a new dummy variable that is equal to 0 if the type of repair is mechanical and 1 if the type of repair is electrical. Develop the multiple regression equation in Excel to predict repair time, given the number of months since the last maintenance service and the type of repair. Letx1represent the number of months since the last maintenance service. Letx2represent the type of repair. If required, round your answers to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300). =+x1+x2 What is the coefficient of determination? If required, round your answers to four decimal places. 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