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 necessar·the managers obtained ist sowing which rea inesi petormed 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. fite repair time in hours months since last service type of repair 2.9 3.0 4.8 electrical mechanical electrical repairperson dave newton dave newton bob jones dave newton 4.9 4.2 4.8 mechanical mechanical electrical electrical bob jones bob jones bob jones dave newton 4.5 a. ignore for now the months since the last maintenance service( and the repairperson who performed the service. develop the estimated simple linear regression equation to predict the repair time (v) given the type of repair (ะ2 ). recall that 0 if the type of repair is mechanical and 1 if the type of repair is electrical (to 2 decimals). time = type b. does the equation that you developed in part (a) provide a good fit for the observed data? explain. select your answer- 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 n-0 f bob jones performed the service and dave newton performed the service (to 2 decimals). time-- person - select your answer- d. does the equation that you developed in part (c) provide a good fit for the observed data? explain. select your answer