Question

The exercise involving data in this and subsequent sections were designed to be solved using Excel Johnson Filtration, Inc. provides maintenance service for water-filtration systems. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Click on the datafile logo to reference the data. DATA Excel or Minitab users: The data set is available in file named Repair, All data sets can be found in your eBook or on your Student CD Repair Time in Hours 2.9 3.0 4.8 Menths Since Last Service Type of Repair Electrical Mechanical Dave Newton Dave Newton Bob Jones Dave Newton Dave Newton Bob Jones Bob Jones Bob Jones Bob Jones Dave Newton Mechanical Electrical 2.9 4.9 Mechanical Mechanical Electrical Electrical 4.8 4.5 a. Ignore or now the months since the last maintenance service 衢 and the repa rperson who per or me if the type of repair is mechanical and 1 if the type of repair is electrical (to 2 decimals). the service eve op the estimate ฐ mp e linear regression equation to predict the repair time Y) g ven the type o repair Tz Recall that 0 Time- : 38.98 11 # Type b. Does the equation that you developed in part (a) provide a good fit for the observed data? Explain. Select your answer- v c. Ignore for now the months since the last maintenance service and the type of repair associated with the machine. Develop the estimated simple linear regression equation to predict the repair time given the repairperson who performed the service. Let 23 0 if Bob Jones performed the service and s1 if Dave Newton performed the service (to 2 decimals) Time = d. Does the equation that you developed in part (c) provide a good fit for the observed data? Explain. Select your answer- v Porson Select your answer

Answer 1