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
Essentials of Business Analytics (MindTap Course List)
- If you are performing a break-even analysis for a business and their cost and revenue equations are dependent, explain what this means for the company's profit margins.arrow_forwardIf you graph a revenue and cost function, explain how to determine in what regions there is profit.arrow_forwardcan a cause and effect relationship be determined?arrow_forward
- A bottling company offers three kinds of delivery service: instant, same day, and within five days. The profit per delivery varies according to the kind of delivery. The profit for an instant delivery is less than the other kinds because the driver has to go directly to a grocery store with a small load and return to the bottling plant. To find out what effect each type of delivery has on the profit picture, the company summarized the data in the following table based on deliveries for the previous quarter: Type of Delivery Instant Same day Within five days Frequency per Quarter 60 50 90 What is the weighted mean profit per delivery? Profit per Delivery 100 110 150arrow_forwardPeter Thompson, in charge of office supplies at Top Hill Estates., would like to predict the quantity of paper used in the office photocopying machines per month. He believes that the number of clients seen in a month influences the volume of photocopying performed. He has compiled the following recent monthly data: (You are to use Excel for this problem) Number of clients in a Month Sheets of Photocopy Paper Used (1000's) 40 26 50 54 40 23 34 52 24 12 25 26 22 15 22 26 a. Develop the least squares estimated regression equation that relates sheets of photocopy paper used to the number of clients. b. Use the regression equation developed in part (a) to forecast the amount of paper used in a month when 36 clients are expected. c. Compute SSE, SST, and SSR.arrow_forwardA company that focuses on research and development (R&D) is interested in the relationship between profit and some variables that can explain profit variations. They want to predict the profits of some new and exciting projects because some are risky. The predictor variables considered are: RISK which is a company derived metric, R&D which is the research and development costs, REGION (WC, EC and KZN) and average per capita income (INCOME in R1000.00). The analyst decides to estimate the regression function with the following response function. Ý (profit) = bo + b₁XRisk + b₂XR&D + b3Xwc + b4Xec + b5XINC Answer the following questions. 4.1. The analyst considered the fact that the effects of multicollinearity may influence some analytical and visual conclusions. Use the following results to show the process of establishing by using extra sums of squares whether there is that multicollinearity present or not. Explain and interpret in detail. SSR(X) = 2573.72, SSR(X₁) = 2600.7, SSR(X₂|…arrow_forward
- A company that focuses on research and development (R&D) is interested in the relationship between profit and some variables that can explain profit variations. They want to predict the profits of some new and exciting projects because some are risky. The predictor variables considered are: RISK which is a company derived metric, R&D which is the research and development costs, REGION (WC, EC and KZN) and average per capita income (INCOME in R1000.00). The analyst decides to estimate the regression function with the following response function. Ỹ (profit) = bo + b₁XRisk + b₂X R&D +b3Xwc + b₁XEC + b₂XINC Answer the following questions. 4.1. The analyst considered the fact that the effects of multicollinearity may influence some analytical and visual conclusions. Use the following results to show the process of establishing by using 5 extra sums of squares whether there is that multicollinearity present or not. Explain and interpret in detail. SSR(X) = 2573.72, SSR(X₁) = 2600.7,…arrow_forwardA company that focuses on research and development (R&D) is interested in the relationship between profit and some variables that can explain profit variations. They want to predict the profits of some new and exciting projects because some are risky. The predictor variables considered are: RISK which is a company derived metric, R&D which is the research and development costs, REGION (WC, EC and KZN) and average per capita income (INCOME in R1000.00). The analyst decides to estimate the regression function with the following response function. Y (profit) = bo + b₁XRisk + b₂XR&D +b3Xwc + b₁XEC + b5XINC Answer the following questions. 4.1. The analyst considered the fact that the effects of multicollinearity may influence some analytical and visual conclusions. Use the following results to show the process of establishing by using 5 extra sums of squares whether there is that multicollinearity present or not. Explain and interpret in detail. SSR (X) = 2573.72, SSR(X₁) = 2600.7, SSR(X₂|…arrow_forwardAn business reviews data on the daily amount of calls it receives. Are the data discrete or continous?arrow_forward
- Make sure to upload here the printscreen solution and interpretation before going to the next problem. Save file as pdf. Analysis using systemic sampling was done inside a production plant producing 15,000 cans of drinks a day. This was done to determine any glitch or problems in the 5-production line as presented in the table. The results showed how high the rate of efficiencies from the different batches. a. Determine whether there is significant difference among the batches. b. Which batch had a significance among the production? c. Are the samples homogeneous? d. Are the samples equal? c. Presenting the Q-Q plot, are the data normal? B1 B2 B3 В4 B5 98 98 90 97 95 95 98 97 94 90 90 95 90 97 96 95 95 95 90 96 90 93 98 95 94arrow_forwardJensen Tire & Auto is deciding whether to purchase a maintenance contract for its newcomputer wheel alignment and balancing machine. Managers feel that maintenance expenseshould be related to usage, and they collected the following information on weeklyusage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. Whatdoes the scatter chart indicate about the relationship between weekly usage and annualmaintenance expense?b. Use the data to develop an estimated regression equation that could be used to predictthe annual maintenance expense for a given number of hours of weekly usage. Whatis the estimated regression model? c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.05level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of…arrow_forwardName the forecasting methodsarrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning