![Essentials Of Business Analytics](https://www.bartleby.com/isbn_cover_images/9781285187273/9781285187273_largeCoverImage.gif)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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 4 Solutions
Essentials Of Business Analytics
- 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 company provides maintenance service for water-filtration systems throughout southern Florida. Customers contact the company with requests for maintenance service on their water-filtration systems. To estimate the service time and the service cost, the company'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 performed the service. Data for a sample of 10 service calls are reported in the table below. Repair Timein Hours Months SinceLast 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.5 2 Electrical Dave Newton 4.9 7 Electrical Bob Jones 4.6 9 Mechanical Bob Jones 4.8 8 Mechanical Bob…arrow_forwardA company provides maintenance service for water-filtration systems throughout southern Florida. Customers contact the company with requests for maintenance service on their water-filtration systems. To estimate the service time and the service cost, the company'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 performed the service. Data for a sample of 10 service calls are reported in the table below. Repair Time Months Since in Hours Last Service 2.9 3.0 4.8 1.8 2.5 4.9 4.2 4.8 4.4 4.5 2 6 8 3 2 7 9 8 4 6 Type of Repair Repairperson Electrical Mechanical Electrical Mechanical Electrical Electrical Mechanical Mechanical Electrical Electrical Dave Newton ŷ = X Check which variable(s)/term(s) should be in your…arrow_forwardThe table so the left side of data is cubic feet moved and right side is labor hoursarrow_forward
- Sheila's doctor is concerned that she may suffer from gestational diabetes (high blood glucose levels during pregnancy). There is variation both in the actual glucose level and in the blood test that measures the level. A patient is classified as having gestational diabetes if her glucose level is above 155 milligrams per deciliter (mg/dl) one hour after a sugary drink. Sheila's measured glucose level one hour after the sugary drink varies according to the Normal distribution with μ = 140 mg/dl and σ = 11 mg/dl.Let X = Sheila's measured glucose level one hour after a sugary drink(a) P(X > 155) = (Use 3 decimal places)Suppose measurements are made on 3 separate days and the mean result is compared with the criterion 155 mg/dl.(b) P(X > 155) = (Use 3 decimal places)(c) What sample mean blood glucose level is higher than 95% of all other sample mean blood glucose levels? Hint: this requires a backward Normal calculation. (Use 2 decimal places)arrow_forwardSee attachmentarrow_forwardThe r code for side by side boxplot of vitamind v newage and vitamin d v country. Scatterplot code for relationship between vitamin d level and age.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_forwardJust do d and e optionsarrow_forwardSuppose an oceanographer monitors the daily salinity of a particular ocean in relation to the temperature of the water. The oceanographer plots the data with temperature, in degrees Celsius (°C), along the horizontal axis and salinity, in parts per thousand (ppt), along the vertical axis. Select the true statement about the data point identified by the arrow. An ocean temperature of 21 °C causes the salinity to be 29 ppt. The predicted salinity is 29 ppt when the ocean temperature for the day is 21 °C. An ocean temperature of 29 °C corresponds to a salinity level of 21 ppt. The observed salinity is 29 ppt when the ocean temperature for the day is 21 °C. There is no relationship between the temperature of the ocean on a given day and salinity.arrow_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
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781938168383/9781938168383_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337111348/9781337111348_smallCoverImage.gif)