Johnson's management team wants to try to understand the relationship between repair time and the other variables using linear regression. They want to compare mechanical failures to the base case of electrical failures and they want to compare repair times of individual repair persons to that of (the base case of) Bob Jones. Remember that the base case for each factor does not have a variable associated with it. Also remember that dummy variables only take on the values of 0 or 1. For this question, create the dummy variables for type of repair and for repair persons. To show that you have created the variables correctly, add the values of the 0s and 1s for all of the dummy variables you've created for all 41 rows of data. (Remember that row 1 is a label row, so even there there are 42 rows in the Filtration sheet, there are only 41 rows of data.) using the dummy variables you created together with the "Months Since Last Service" variable as independent variables, create a regression model that can be used to predict Repair Time. What proportion of variation in repair time is explained by the independent variables? Report your answer to 3 decimal places. I want you to enter this number as a proportion Using the estimated equation/model you found in the previous question, what do you estimate the repair time to be for a system that was last serviced 9 months ago that is to be repaired by Dave Newton, and which has an electrical failure type. Report your answer to two decimal places.
Repair Time Months Since Last Service 13.8 Failure Type Repairperson Linda Mechanical Anderson Linda Electrical Anderson Electrical Bob Jones Linda Electrical Anderson 14.1 15.7 14.5 Dave 13.3 Mechanical Newton Electrical Bob Jones Linda Mechanical Anderson Dave Mechanical Newton Dave Electrical Newton Linda Electrical Anderson Electrical Bob Jones Dave Mechanical Newton Dave Mechanical Newton Linda Electrical Anderson Linda Mechanical Anderson Linda Electrical Anderson Dave Mechanical Newton Linda Electrical Anderson Linda Electrical Anderson io sono 15.2 14.2 11:13 14.1 11 13 13.9 16 16 12.2 Win 000 Electrical Newton Linda Mechanical Anderson Electrical Bob Jones Electrical Bob Jones Linda Electrical Anderson Electrical Bob Jones Dave Electrical Newton Dave Electrical Newton Electrical Bob Jones Electrical Bob Jones Dave Mechanical Newton Linda Mechanical Anderson Linda Electrical Anderson Dave Mechanical Newton Linda Electrical Anderson Dave Mechanical Newton Electrical Bob Jones Dave Mechanical Newton Dave Mechanical Newton Dave Mechanical Newton Linda Mechanical Anderson Dave Mechanical Newton 12.8 11.6