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:
- 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?
- 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?
- 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?
- 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?
- 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?
- f. Which of these models would you use? Why?
a.
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
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:
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
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:
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.
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:
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:
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:
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:
Similarly, the predicted and residual values for all the observations are calculated and given in the ascending order by residuals as follows:
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:
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:
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:
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:
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.
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:
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:
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:
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.
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:
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:
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:
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.
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:
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:
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:
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.
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?
Chapter 7 Solutions
Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams' Essentials Of Business Analytics, 2nd
- There are four white, fourteen blue and five green marbles in a bag. A marble is selected from the bag without looking. Find the odds of the following: The odds against selecting a green marble. The odds in favour of not selecting a green marble The odds in favor of the marble selected being either a white or a blue marble. What is true about the above odds? Explainarrow_forwardPlease show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy. 1. The probability of a soccer game in a particular league going into overtime is 0.125. Find the following: a. The odds in favour of a game going into overtime. b. The odds in favour of a game not going into overtime. c. If the teams in the league play 100 games in a season, about how many games would you expect to go into overtime?arrow_forwardexplain the importance of the Hypothesis test in a business setting, and give an example of a situation where it is helpful in business decision making.arrow_forward
- A college wants to estimate what students typically spend on textbooks. A report fromthe college bookstore observes that textbooks range in price from $22 to $186. Toobtain a 95% confidence level for a confidence interval estimate to plus or minus $10,how many students should the college survey? (We may estimate the populationstandard deviation as (range) ÷ 4.)arrow_forwardIn a study of how students give directions, forty volunteers were given the task ofexplaining to another person how to reach a destination. Researchers measured thefollowing five aspects of the subjects’ direction-giving behavior:• whether a map was available or if directions were given from memory without a map,• the gender of the direction-giver,• the distances given as part of the directions,• the number of times directions such as “north” or “left” were used,• the frequency of errors in directions. Identify each of the variables in this study, and whether each is quantitative orqualitative. For each quantitative variable, state whether it is discrete or continuous. Was this an observational study or an experimental study? Explain your answer.arrow_forwardexplain the difference between the confident interval and the confident level. provide an example to show how to correctly interpret a confidence interval.arrow_forward
- Sketch to scale the orbit of Earth about the sun. Graph Icarus’ orbit on the same set of axesWhile the sun is the center of Earth’s orbit, it is a focus of Icarus’ orbit. There aretwo points of intersection on the graph. Based on the graph, what is the approximate distance between the two points of intersection (in AU)?arrow_forwardThe diameters of ball bearings are distributed normally. The mean diameter is 67 millimeters and the standard deviation is 3 millimeters. Find the probability that the diameter of a selected bearing is greater than 63 millimeters. Round to four decimal places.arrow_forwardSuppose you like to keep a jar of change on your desk. Currently, the jar contains the following: 22 Pennies 27 Dimes 9 Nickels 30 Quarters What is the probability that you reach into the jar and randomly grab a penny and then, without replacement, a dime? Express as a fraction or a decimal number rounded to four decimal places.arrow_forward
- A box contains 14 large marbles and 10 small marbles. Each marble is either green or white. 9 of the large marbles are green, and 4 of the small marbles are white. If a marble is randomly selected from the box, what is the probability that it is small or white? Express as a fraction or a decimal number rounded to four decimal places.arrow_forwardCan I get help with this step please? At a shooting range, instructors can determine if a shooter is consistently missing the target because of the gun sight or because of the shooter's ability. If a gun's sight is off, the variance of the distances between the shots and the center of the shot pattern will be small (even if the shots are not in the center of the target). A student claims that it is the sight that is off, not his aim, and wants the instructor to confirm his claim. If a skilled shooter fires a gun at a target multiple times, the distances between the shots and the center of the shot pattern, measured in centimeters (cm), will have a variance of less than 0.33. After the student shoots 28 shots at the target, the instructor calculates that the distances between his shots and the center of the shot pattern, measured in cm, have a variance of 0.25. Does this evidence support the student's claim that the gun's sight is off? Use a 0.025 level of significance. Assume that the…arrow_forwardThe National Academy of Science reported that 38% of research in mathematics is published by US authors. The mathematics chairperson of a prestigious university wishes to test the claim that this percentage is no longer 38%. He has no indication of whether the percentage has increased or decreased since that time. He surveys a simple random sample of 279 recent articles published by reputable mathematics research journals and finds that 123 of these articles have US authors. Does this evidence support the mathematics chairperson's claim that the percentage is no longer 38 % ? Use a 0.02 level of significance. Compute the value of the test statistic. Round to two decimal places.arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL