Johnson Filtration, Inc., provides maintenance service for water-filtration systems throughout southern Florida. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtaine showing which repairperson performed the service. The revised data follow. Time by+by Months + b₂ Type +by Person Round your answers to three decimal places. bo Repair Time in Hours 2.8 3.0 4.7 Use Table 2 from Appendix B to determine the p-value. The p-value is less than 0.01 1.9 2.9 4.8 4.2 4.9 4,3 "What is your conclusion? The addition of Person is What explanation can you give for the results observed? Person is highly correlated with type of repair Months Since Last Service a. Develop the estimated regression equation to predict the repair time given the number of months since the last maintenance service, the type of repair, and the repairperson who performed the service. Assume that ₂-1 if the type of repair is electrical and = 1 if Dave Newton performed service. Enter negative value as negative number. Use Table 4 from Appendix B to determine the p-value. The p-value is less than 0.01 "What is your conclusion? The overall model is not statistically significant v c. Is the addition of the independent variable #3, the repairperson who performed the service, statistically significant? Use a = 0.05. Compute the test statistic for the significance of 3 (to 2 decimals). Enter negative value as negative number. ✓statistically significant. 2 6 8 3 2 7 b₂ by by b. At the 0.05 level of significance, test whether the estimated regression equation developed in part (a) represents a significant relationship between the independent variables and the dependent variable. Compute F test statistic (to 2 decimals). Type of Repair Electrical Mechanical Electrical Mechanical Electrical Electrical Mechanical Mechanical Electrical Electrical Repairperson Dave Newton Dave Newton Bob Jones Dave Newton Dave Newton Bob Jones Bob Jones Bob Jones Bob Jones Dave Newton so once the effect of that is accounted for the addition of person will not add much.

When the variables are associated with each other, one variable is used to find the value of the other variable. The method used to predict the value of the variable is called as regression analysis.. When there are more than two independent variable used for predicting the value of the variable is called as the multiple regression.The variables under study are repair time month since the last serviceThe data is YX1X2X32.821136014.78101.93012.92114.87104.29004.98004.34104.4611The Excel procedure to find the regression model from the dataExcel Procedure:Enter the variables in the columns of the Excel sheet.From Data > Data Analysis > RegressionSelect an Input Y-range as a value of variable time of repairSelect Input X-range as a month, type, and the repair person.Click on OK.The output isFrom the output the fitted regression model isThe hypothesis of the testing is there is no relationship between the independent and the dependent variable. There is a relationship between the independent and the dependent variable.The test statistics isThe degrees of freedom isUse the Excel command to find the p-valueCommand2*(1-F.DIST(15.7746,3,6,TRUE))Value0.005963The p-value .As , reject .The relationship between variables are significance.The hypothesis of the testing isthe test statistics is from the output in step the p-value for the testing isThe p-value.The addition of a person is not statistically significant.The person and the month is highly correlated with each other.The regression model on the data is the -statistics for testing the overall model significance The p-value is less than.. The conclusion is overall model is statistically significant.The test statistics for testing the significance of the addition of the variable person The p-value is greater than.. The conclusion is the addition of a person is not statistically significant. The person is highly correlated with the month since the last service, so once the effect of that is accounted for addition of person will not add so much.

Related questions