d)
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.8249 | |||||
R Square | 0.6805 | |||||
Adjusted R Square | 0.5892 | |||||
Standard Error | 0.6915 | |||||
Observations | 10 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 2 | 7.1291 | 3.5646 | 7.4553 | 0.0184 | |
Residual | 7 | 3.3469 | 0.4781 | |||
Total | 9 | 10.476 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 3.5263 | 0.9381 | 3.7591 | 0.0071 | 1.3081 | 5.7445 |
X Variable 1 | 0.1519 | 0.1230 | 1.2349 | 0.2567 | -0.1390 | 0.4428 |
X Variable 2 | -1.0835 | 0.6051 | -1.7907 | 0.1165 | -2.5144 | 0.3473 |
e) When Electrical=1 and Mechanical=0
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.9120 | |||||
R Square | 0.8317 | |||||
Adjusted R Square | 0.7475 | |||||
Standard Error | 0.5421 | |||||
Observations | 10 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 3 | 8.7127 | 2.9042 | 9.8820 | 0.0097 | |
Residual | 6 | 1.7633 | 0.2939 | |||
Total | 9 | 10.476 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 2.6035 | 0.8360 | 3.1142 | 0.0207 | 0.5578 | 4.6492 |
X Variable 1 | 0.2039 | 0.0990 | 2.0598 | 0.0851 | -0.0383 | 0.4462 |
X Variable 2 | 0.9135 | 0.3936 | 2.3213 | 0.0593 | -0.0495 | 1.8765 |
X Variable 3 | -1.0893 | 0.4744 | -2.2961 | 0.0614 | -2.2502 | 0.0715 |
Repair Time in Months Since Last Hours 2.9 3.0 Service 2 6 8 3 2 7...
Johnson Filtration, Inc., provides maintenance service for water fitration 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 manacers want to predict the repair time necessary or each maintenance request. Hence, repair time in hours is the dependent variable. Repair tme is believed to be related to three factors; the number of months snce the as maintenance service, the type of repair...
1. 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 check the conditions necessary for valid inference in regression, and 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...
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 obtained a list showing which repairperson performed the service. The revised data follow Repair Time in Hours 3.0 3.1 Months Since Last Service 2 6 8 3 2 7 Type of Repair Electrical Mechanical Electrical Mechanical Electrical Electrical Mechanical Mechanical...
Months Repair Since Time Last Type of (hours) Service Repair Service person if_Dave if_Bob electrical Dave Newton 2 2.9 6 mechanicDave Newton 3.0 8 electrical Bob Jones 4.8 mechanic Dave Newton 3 1.8 electrical Dave Newton 2 2.9 electrical Bob Jones 7 4.9 ones 9 mechanic Bob J 4.2 8 mechanic Bob Jones 4.8 electrical Bob Jones 4 4.4 6 electrical Dave Newton 4.5 Consider Problem REPAIR. Ignore "months since last service" and "service person". Use "type of repair" to...
part (a) is shown in the question I just posted before this The question was too big to put into one question (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 If required, round your answers to four decimal places Repair Time Months Since Predicted Repair in Hours 1.8 3.0 4.2 2.9 2.9 4.8 4.8 4.5 4.9 4.4 Last Service Type of...
IN A EXCEL FILE USING EXCEL FORMULAS AND CALCULATIONS MUST SHOE FORMULAS IN CELL! SHOW THE STEPS IN SOLUTION APPROACH. Refer to the Johnson Filtration problem introduced in this section. 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 obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type...
For each part of the question what steps do I need to take in minitab to find this answer? Months Since Type of Repair Time (hours) Last ServiceRepair Repairperson electrical Dave Newton mechanical Dave Newtorn electricalBob Jones mechanical Dave Newton electrical Dave Newton 4.8 4.9 7 electrical Bob Jones d Minitab output if you used mechanical Bob Jonesi mechanical Bob Jones electrical Bob Jones 4.2 4.8 4.4 ltration, Inc. provides maintenance service for water-filtration systems ohnson Filtration. throughout southern Florida....
The exercise involving data in this and subsequent sections were designed to be solved using Excel Johnson Filtration, Inc. provides maintenance service for water-filtration systems. 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 obtained a list showing which repairperson performed the service. The revised data follow. Click on the datafile logo to reference the data. DATA Excel or Minitab users:...
DATAnle: Repair A statistical program is recommended. samples 10 W e eported the table Sesw.ved to type of repair problem mechanical order , and the pairperson who performed the service. Bata rör Repair Time Months Since in Hours Type of Repair Repairperson Last Service 2.9 Electrical Dave Newton 6 Mechanical Dave Newton 4.8 Electrical Bab Jones 3.0 Mechanical Dave Newton Electrical Dave Newton Electrical 4.2 9 Mechanical Mechanical Bab Jones Bab Jones Bab Jones Electrical Bob Jones Flectrical Dave Newton...
Problem 7-9 Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow. Weekly Gross Revenue ($100s) Television Advertising Newspaper Advertising ($100s) ($100s) Market Mobile 101.3 4.9 1.4 Shreveport 52.9 3.1 3.2 Jackson 75.8 4.2 1.5 Birmingham 127.2 4.5 4.3 Little Rock 137.8 3.6 4...