Create a new dummy variable that is equal to zero if the repair person is Bob Jones and one if the repair person is Donna Newton Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the repair person What is the coefficient of determination Four decimal places in Excel 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

The Answer is in the image, click to view ...

Question: Create a new dummy variable that is equal to zero if the repair person is Bob Jones and one if the repair person is Donna

Create a new dummy variable that is equal to zero if the repair person is Bob Jones and one if the repair person is Donna Newton. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the repair person. What is the coefficient of determination? Four decimal places in Excel.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

(c) Create a new dummy variable that is equal to 0 if the type of repair is mechanical and 1 if the type of repair is electrical. Develop the multiple regression equation in Excel to predict repair...

A maintenance service would like to predict the service time for maintenance requests. They have gathered some data from the last 10 requests: repair time, months since last service, type of repair,...

Johnson Filtration, Inc. provides maintenance service for water filtration systems throughout Southern Florida. Customers contact Johnson with requests for maintenance service on their water...

Johnson Filtration, Inc., provides maintenance service for water filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water...

XYZ company provides maintenance service for water filtration systems in London. Customers contact XYZ with requests for maintenance service on their water filtration systems. To estimate the service...

Johnson Filtration, Inc., provides maintenance service for water filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water...

If required, round your answers to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: - 300). 9. x Use the results to test...

Johnson Filtration, Inc., provides maintenance service for water filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water...

Johnson Filtration, Inc. provides maintenance service for water filtration systems throughout Southern Florida. Customers contact Johnson with requests for mainte- nance service on their water...

(a) Who controls the closely held corporation? Explain. (b) Describe five techniques that a corporation might use to avoid the double taxation of corporate profits.

Suppose that we estimate the standard deviation of a portfolio P to be 10%, the covariance between P and the market portfolio to be 0.00576, and the standard deviation of the market portfolio to be...

A firm that controls the production of inputs into its final product is called a

Need help! Resting Recliner Chairs completed the following selected transactions: 1) (Click the icon to view the transactions.) Begin with the transactions for 2024 . Jul. 1: Sold inventory to Gray...

=+putting it away for a year in a bank account that pays 5 percent interest. What is the opportunity cost of spending the $100 now?

=+ e. a recent college graduate deciding whether to go to graduate school

=+go skiing. What is the true cost of going skiing? Now suppose you had been planning to spend the day studying at the library. What is the cost of going skiing in this case? Explain.