Essentials of Business Analytics (MindTap Course List)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Book Icon
Chapter 7, Problem 13P

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 the service time and the service cost. Johnson’s 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:

Chapter 7, Problem 13P, Johnson Filtration. Inc., provides maintenance service for water filtration systems throughout

  1. a. Develop the simple linear regression equation to predict repair time given the number of months since the last maintenance service, and use the results to test the hypothesis that no relationship exists between repair time and the number of months since the last maintenance service at the 0.05 level of significance. What is the interpretation of this relationship? What does the coefficient of determination tell you about this model?
  2. b. Using the simple linear regression model developed in part (a), calculate the predicted repair time and residual for each of the 10 repairs in the data. Sort the data in ascending order by value of the residual. Do you see any pattern in the residuals for the two types of repair? Do you see any pattern in the residuals for the two repairpersons? Do these results suggest any potential modifications to your simple linear regression model? Now create a scatter chart with months since last service on the x-axis and repair time in hours on the y-axis for which the points representing electrical and mechanical repairs are shown in different shapes and/or colors. Create a similar scatter chart of months since last service and repair time in hours for which the points representing repairs by Bob Jones and Donna Newton are shown in different shapes and/or colors. Do these charts and the results of your residual analysis suggest the same potential modifications to your simple linear regression model?
  3. c. Create a new dummy variable that is equal to zero if the type of repair is mechanical and one if the type of repair is electrical. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the type of repair. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model?
  4. d. Create a new dummy variable that is equal to zero if the repairperson is Bob Jones and one if the repairperson is Donna Newton. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model?
  5. e. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the type of repair, and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model?
  6. f. Which of these models would you use? Why?

a.

Expert Solution
Check Mark
To determine

Find an estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service.

Test whether there is any relationship between the repair time and the number of months since the last maintenance service using the level of significance of 0.05. Interpret the test results.

Interpret the value of coefficient of determination.

Answer to Problem 13P

The estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service, is Repair time^=2.1473+0.3041(Months since the last service).

There is sufficient evidence to conclude that there is a linear relationship between the repair time and the number of months since the last maintenance service.

The amount of variation explained in the repair time by the number of months since the last maintenance service is 53.42%.

Explanation of Solution

Calculation:

Here, the repair time is the dependent variable, and the number of months since the last maintenance service is the independent variable.

Step-by-step procedure to obtain the estimated regression equation using EXCEL is defined as follows:

  • In EXCEL sheet, enter Repair time in Hours and Months since the last service in columns A and B, respectively.
  • In Data, select Data Analysis and choose Regression.
  • In Input Y Range, select $A$1:$A$11.
  • In Input X Range, select $B$1:$B$11.
  • Select Labels.
  • Click OK.

Output obtained using EXCEL is given below:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  1

Thus, the estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service, is Repair time^=2.1473+0.3041(Months since the last service).

The null and alternative hypotheses to test whether there is a relationship between repair time and the number of months since the last maintenance service are given as follows:

H0:β1=0Ha:β10

It is given that the level of significance is 0.05.

From the above output, the P-value is 0.0163.

Decision rule:

The null hypothesis is rejected if the P-value is less than or equal to the level of significance. Otherwise, do not reject the null hypothesis.

Here, the P-value of 0.0163 is less than the level of significance (0.05). Hence, the null hypothesis is rejected.

Therefore, there is sufficient evidence to conclude that there is a linear relationship between the repair time and the number of months since the last maintenance service.

Coefficient of determination:

The coefficient of determination (R-square) value explains the percentage of variation explained in the dependent variable by the independent variables.

From the given output, the value of R-square is approximately 0.5342. That is, the amount of variation explained in the repair time by the number of months since the last maintenance service is 53.42%.

b.

Expert Solution
Check Mark
To determine

Find the predicted repair time and residual for each of the 10 repairs.

Arrange the data in the ascending order by value of the residual. Is there any pattern observed in the residuals in the two types of repairs. Is there any pattern observed in the residuals in the two repairpersons. Explain whether these results suggest any modifications to the obtained regression model.

Construct a scatterplot with months since the last maintenance service on the x-axis and repair time on the y-axis and differentiate the points between two types of repairs.

Construct a scatterplot with months since the last maintenance service on the x-axis and repair time on the y-axis and differentiate the points between two types of repair persons.

Explain whether these results suggest any modifications to the obtained regression model.

Answer to Problem 13P

The predicted and residual values for all the observations are calculated and given in ascending order by residuals as follows:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  2

From the above result, mechanical repairs are generally negative residual values and electrical repairs have positive residual values. That is, the mechanical repairs take less time when compared to electrical repairs.

The first two large negative residuals are made by Donna Newton. The residuals of Bob Jones are positive. That is, the repairs by Bob Jones take more time than the predicted values.

The scatterplots obtained using EXCEL are given below:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  3

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  4

The above results suggest including these categorical variables into the regression model by creating dummy variables.

Explanation of Solution

Calculation:

From the given dataset, the first observation of Months since last service is 2.

The predicted repair time for the first observation is calculated as follows:

Repair time^=2.1473+0.3041(Months since the last service)=2.1473+0.3041(2)2.7555

Thus, the predicted repair time is 2.7555 hours.

The observed repair time for the first observation is given as 2.9 hours.

The residual of the first observation is calculated as follows:

Residual=(Observed value of y)(Predicted value of y)=2.92.7555=0.1445

Similarly, the predicted and residual values for all the observations are calculated and given in the ascending order by residuals as follows:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  5

From the above result, mechanical repairs are generally negative residual values and electrical repairs have positive residual values. That is, the mechanical repairs take less time when compared to electrical repairs.

The first two large negative residuals are made by Donna Newton. The residuals of Bob Jones are positive. That is, the repairs by Bob Jones take more time than the predicted values.

The above results suggest including these categorical variables into the regression model by creating dummy variables.

Separate the above data into two tables with respect to the type of repair considering months since last service as follows:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  6

Step-by-step procedure to obtain the scatterplot using EXCEL is given as follows:

  • Select the first data with labels.
  • Go to Insert, select Charts and select Scatterplot.
  • A scatterplot will be displayed.
  • Select and copy the second data with labels.
  • Click on the scatterplot and click on Paste.
  • Select Paste special.
  • Select New series and Columns.
  • Select Series names in first row and Categories (X values) in first column.
  • Click OK.

Output obtained using EXCEL is given below:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  7

The above chart indicates that the electrical repairs take more time than mechanical repairs.

Separate the above data into two tables with respect to repair person considering months since last service as follows:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  8

Step-by-step procedure to obtain the scatterplot using EXCEL is given as follows:

  • Select the first data with labels.
  • Go to Insert, select Charts and select Scatterplot.
  • A scatterplot will be displayed.
  • Select and copy the second data with labels.
  • Click on the scatterplot and click on Paste.
  • Select Paste special.
  • Select New series and Columns.
  • Select Series names in first row and Categories (X values) in first column.
  • Click OK.

Output obtained using EXCEL is given below:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  9

The above chart indicates that the repairs by Bob Jones take more time than Donna Newton.

The above two scatterplots suggest  including these categorical variables into the regression model by creating dummy variables.

c.

Expert Solution
Check Mark
To determine

Find an estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service and the type of repair.

Interpret the value of coefficient of determination.

Answer to Problem 13P

The estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service and the type of repair, is as follows:

Repair time^=[0.9305+0.3876(Months since the last service)+1.2627(Type of repair)].

It increases every month since the last service will increase the repair time by 0.3876 hours.

The repair time of mechanical repairs is 1.2627 hours less than the repair time of electrical repairs.

The amount of variation explained in the repair time by the number of months since the last maintenance service and the type of repair is 85.92%.

Explanation of Solution

Calculation:

Here, the repair time is the dependent variable. The number of months since the last maintenance service and the type of repair are the independent variables.

Step-by-step procedure to obtain the estimated regression equation using EXCEL is defined as follows:

  • Create a variable type of repair.
  • In the variable type of repair, enter 0 of the repair is mechanical and enter 1 if the repair is electrical.
  • In Data, select Data Analysis and choose Regression.
  • In Input Y Range, select $A$1:$A$11.
  • In Input X Range, select $B$1:$C$11.
  • Select Labels.
  • Click OK.

Output obtained using EXCEL is given below:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  10

Thus, the estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service and the type of repair is as follows:

Repair time^=[0.9305+0.3876(Months since the last service)+1.2627(Type of repair)].

Interpretation of parameters:

It increases every month since the last service will increase the repair time by 0.3876 hours.

The repair time of mechanical repairs is 1.2627 hours less than the repair time of electrical repairs.

From the given output, the value of R-square is approximately 0.8592. That is, the amount of variation explained in the repair time by the number of months since the last maintenance service and the type of repair is 85.92%.

d.

Expert Solution
Check Mark
To determine

Find an estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service and the repair person.

Interpret the value of coefficient of determination.

Answer to Problem 13P

The estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service and the repair person, is as follows:

Repair time^=[3.5263+0.1519(Months since the last service)1.0835(Repairperson)].

It increases every month since the last service will increase the repair time by 0.1519 hours.

The repair time of Bob Jones is 1.0835 hours more than the repair time of Donna Newton.

From the given output, the value of R-square is approximately 0.6805. That is, the amount of variation explained in the repair time by the number of months since the last maintenance service and the repairperson is 68.05%.

Explanation of Solution

Calculation:

Here, the repair time is the dependent variable. The number of months since the last maintenance service and the repair person are the independent variables.

Step-by-step procedure to obtain the estimated regression equation using EXCEL is defined as follows:

  • Create a variable type of repair.
  • In the variable type of repair, enter 0 of the repairperson is Bob Jones and enter 1 if the repairperson is Donna Newton.
  • Place the variables repair time, number of months since the last maintenance service, and the repairperson in the columns A, B, and C, respectively.
  • In Data, select Data Analysis and choose Regression.
  • In Input Y Range, select $A$1:$A$11.
  • In Input X Range, select $B$1:$C$11.
  • Select Labels.
  • Click OK.

Output obtained using EXCEL is given below:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  11

Thus, the estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service and the repairperson, is as follows:

Repair time^=[3.5263+0.1519(Months since the last service)1.0835(Repairperson)].

Interpretation of parameters:

It increases every month since the last service will increase the repair time by 0.1519 hours.

The repair time of Bob Jones is 1.0835 hours more than the repair time of Donna Newton.

From the given output, the value of R-square is approximately 0.6805. That is, the amount of variation explained in the repair time by the number of months since the last maintenance service and the repairperson is 68.05%.

e.

Expert Solution
Check Mark
To determine

Find an estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service, the type of repair, and the repair person.

Interpret the value of coefficient of determination.

Answer to Problem 13P

The estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service, the type of repair, and the repair person is as follows:

Repair time^=[1.8601+0.2914(Months since the last service)+1.1024(Type of repair)0.6091(Repairperson)].

It increases every month since the last service will increase the repair time by 0.2914 hours.

The repair time of mechanical repairs is 1.1024 hours less than the repair time of electrical repairs.

The repair time of Bob Jones is 0.6091 hours more than the repair time of Donna Newton.

From the given output, the value of R-square is approximately 0.9002. That is, the amount of variation explained in the repair time by the number of months since the last maintenance service and the repair person is 90.02%.

Explanation of Solution

Calculation:

Here, the repair time is the dependent variable. The number of months since the last maintenance service, the type of repair, and the repairperson are the independent variables.

Step-by-step procedure to obtain the estimated regression equation using EXCEL is defined as follows:

  • Place the variables’ repair time, number of months since the last maintenance service, the type of repair, and the repair person in the columns A, B, C, and D, respectively.
  • In Data, select Data Analysis and choose Regression.
  • In Input Y Range, select $A$1:$A$11.
  • In Input X Range, select $B$1:$D$11.
  • Select Labels.
  • Click OK.

Output obtained using EXCEL is given below:

Essentials of Business Analytics (MindTap Course List), Chapter 7, Problem 13P , additional homework tip  12

Thus, the estimated regression equation that could be used to predict the repair time, given the number of months since the last maintenance service, the type of repair, and the repair person is as follows:

Repair time^=[1.8601+0.2914(Months since the last service)+1.1024(Type of repair)0.6091(Repairperson)].

Interpretation of parameters:

It increases every month since the last service will increase the repair time by 0.2914 hours.

The repair time of mechanical repairs is 1.1024 hours less than the repair time of electrical repairs.

The repair time of Bob Jones is 0.6091 hours more than the repair time of Donna Newton.

From the given output, the value of R-square is approximately 0.9002. That is, the amount of variation explained in the repair time by the number of months since the last maintenance service and the repair person is 90.02%.

f.

Expert Solution
Check Mark
To determine

Identify the best regression model among the models.

Answer to Problem 13P

The preferable model is the regression model in Part (c).

Explanation of Solution

The R-square value of the regression model in Part (a) is 0.5341. Here, the only independent variable is the number of months since the last maintenance service. Here, the independent variable is significant.

The R-square value of the regression model in Part (c) is 0.8592. Here, the independent variables are the number of months since the last maintenance service and the type of repair. Here, both the independent variables are significant.

The R-square value of the regression model in Part (d) is 0.6805. Here, the independent variables are the number of months since the last maintenance service and the repair person. Here, both the independent variables are insignificant.

The R-square value of the regression model in Part (e) is 0.9002. Here, the independent variables are the number of months since the last maintenance service, the type of repair, and the repair person. Here, the independent variable repair person is insignificant. The value of R-square from the model in Part (c) is increased due to the multicollinearity between the variables such as the number of months since the last maintenance service and the repair person.

The best regression model is always a model with less number of independent variables that are significant and higher value of R-square.

Hence, the preferable model is the regression model in Part (c).

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
How many levels does the independent variable have
Draw a scatter diagram with square feet of living space as the independent variable and selling price as the dependent variable and describe variable and describe the relationship between the size of a house and the selling price.
Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six- week lag between fertilizer sales and mower sales. The pertinent data are: Fertilizer Number of Fertilizer Number of Sales Mowers Sold Sales Mowers Sold Period (tons) (six-week lag) Period (tons) (six-week lag) 1 1.6 10 8. 1.3 7 1.3 8 1.7 10 3 1.8 11 10 1.2 6. 4 2.0 12 1.9 11 2.2 12 12 1.4 1.6 9. 13 1.7 10 7 1.5 14 1.6 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) it appears that a positive v relationship exists between these variables. b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.) Y = O Xi + c. Predict expected lawn mower sales…
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Introduction to experimental design and analysis of variance (ANOVA); Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=vSFo1MwLoxU;License: Standard YouTube License, CC-BY