PLEASE EXPLAIN ONLY USING EXCEL WITH FORMULAS AND SHOW THE EXCEL SHEET PLEASE!

Johnson Filtration, Inc. provides maintenance service for water filtration systems throughout Southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate service time and the service cost, Johnsons managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table:

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

a. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the repairperson and the type of repair.

b. What are the interpretations of the estimated regression parameters?

c. What does the coefficient of determination tell you about this model?