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
- See 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_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
- - х i Data Table ets he Full data set O Assets R&D Expense R&D Expense 712.087 Assets 3,478.557 3,462.224 1,206.455 345.709 7,785.525 389.959 918.899 90.404 117.895 2,390.016 257.571 446.339 47.523 678.531 71.401 1,069.117 2,465.859 3,945.287 168.631 111.724 2,648.273 3,406.446 9,250.323 292.876 224.715 383.186 nt 410.051 988.349 19.257 485.204 55.161 493.116 55.046 2,363.477 251.699 0) 102.148 13.489 221.321 27.958 3,728.419 1,389.377 1,706.486 327.691 1,465.861 158.293 141.616 165.093 19.154 161.317 2,988.141 301.803 nat Print Donearrow_forwardFor each of the following situations, state the independent variable and the dependent variable. a. A study is done to determine if elderly drivers are involved in more motor vehicle fatalities than other drivers. The number of fatalities per 100,000 drivers is compared to the age of drivers. b. A study is done to determine if the weekly grocery bill changes based on the number of family members. c. Insurance companies base life insurance premiums partially on the age of the applicant. d. Utility bills vary according to power consumption. e. A study is done to determine if a higher education reduces the crime rate in a population.arrow_forwardRange of ankle motion is a contributing factor to falls among the elderly. Suppose a team of researchers is studying how compression hosiery, typical shoes, and medical shoes affect range of ankle motion. In particular, note the variables Barefoot and Footwear2. Barefoot represents a subject's range of ankle motion (in degrees) while barefoot, and Footwear2 represents their range of ankle motion (in degrees) while wearing medical shoes. Use this data and your preferred software to calculate the equation of the least-squares linear regression line to predict a subject's range of ankle motion while wearing medical shoes, ?̂ , based on their range of ankle motion while barefoot, ? . Round your coefficients to two decimal places of precision. ?̂ = A physical therapist determines that her patient Jan has a range of ankle motion of 7.26°7.26° while barefoot. Predict Jan's range of ankle motion while wearing medical shoes, ?̂ . Round your answer to two decimal places. ?̂ = Suppose Jan's…arrow_forward
- A sales manager wants to examine the relationship between the number of daily customers (x) and the revenue generated (y). For this purpose, he made observations in a randomly chosen 6 days for a store and observed the number of daily customers and the revenue (1000 TL). The personally created data set for the x and y variables is included in the attached “Homework data” file. Using the data set defined on your behalf; x1 x2 x3 x4 x5 x6 y1 y2 y3 y4 y5 y6 sb1 Burak data 74 86 96 105 110 124 290 307 331 406 421 481 0.491 a) Create the regression equation b) Interpret b0 and b1 values c) Test and interpret whether there is a linear relationship between the number of daily customers and the income obtained at the level of α = 0.05 significance. Could you explain this question again and in more detail especially not in excel imagearrow_forwardResearchers initiated a long-term study of the population of American black bears. One aspect of the study was to develop a model that could be used to predict a bear's weight (since it is not practical to weigh bears in the field). One variable thought to be related to weight is the length of the bear. The accompanying data represent the lengths and weights of 12 American black bears. Complete parts (a) through (d) below. Click the icon to view the data table. Click the icon to view the critical values table. ..... (a) Which variable is the explanatory variable based on the goals of the research? O A. The number of bears B. The weight of the bear O C. The length of the bear (b) Draw a scatter diagram of the data. Choose the correct graph below. O A. O B. O C. D. A Weight (kg) 180- AWeight (kg) 180- ALength (cm) 180- A Weight (kg) 180- 40- 100 40- 100 Length (cm) 40- 100 40- 100 200 200 200 200 Length (cm) Weight (kg) Length (cm) (c) Determine the linear correlation coefficient between…arrow_forwardAn insurance company wants to know if the average speed at which men drive cars is higher than that of women drivers. Which of the following is NOT a possible confounding variable and choice to address that variable? Road conditions, so the speeds should be measured at the same sites. Make of car, so the researchers should pick one make and only measure that. Amount of traffic, so the speeds should be measured at the same time of day. Type of driver, so commercial vehicles should be orch JE.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