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. Repair Time (hours) Months Since Last Service Type of Repair Repairperson 2.9 2 electrical Dave Newton 3.0 6 mechanical Dave Newton 4.8 8 electrical Bob Jones 1.8 3 mechanical Dave Newton 2.9 2 electrical Dave 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 Dave Newton Ignore for now the months since the last maintenance service (x1 ) and the repairperson who performed the service. Develop the estimated simple linear regression equation to predict the repair time (y) given the type of repair (x2 ). Recall that x2 = 0 if the type of repair is mechanical and 1 if the type of repair is electrical (to 2 decimals). Time = + Type 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. Letx3 = 0 if Bob Jones performed the service and x3 = 1 if Dave Newton performed the service (to 2 decimals). Time = ____ ____ Person
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.
|
Repair Time |
Months Since |
Type of |
Repairperson |
|
2.9 |
2 |
electrical |
Dave Newton |
|
3.0 |
6 |
mechanical |
Dave Newton |
|
4.8 |
8 |
electrical |
Bob Jones |
|
1.8 |
3 |
mechanical |
Dave Newton |
|
2.9 |
2 |
electrical |
Dave 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 |
Dave Newton |
Ignore for now the months since the last maintenance service (x1 ) and the repairperson who performed the service. Develop the estimated simple linear regression equation to predict the repair time (y) given the type of repair (x2 ). Recall that x2 = 0 if the type of repair is mechanical and 1 if the type of repair is electrical (to 2 decimals).
Time = + Type
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. Letx3 = 0 if Bob Jones performed the service and x3 = 1 if Dave Newton performed the service (to 2 decimals).
Time = ____ ____ Person
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
