Marina maintenance agency maintains its properties in Media City. It receives ca

Question

Marina maintenance agency maintains its properties in Media City. It receives call from the residents of its properties and classifies the problem as either plumbing or electrical. Currently the agency has two employees: Sam and Bob. The following dataset shows the data of the ten jobs completed by them.

Between the employees, who takes more time to repair and by how many hours?

Is the overall test significant at =0.10? Provide your reasons.

Rank the variables from one which explains the most to the least of repair time

How many outliers are there in the dataset based on the 2 standard deviation criteria?

Days sinceProblem Employee type (X2) Days sinceProblemEmployee last service Repair time in last service Repair time in hours (Y) hours (Y) 4.7 7.5 Normalize the data as: if (Problem) is Plumbing, then (X2) equal to one if (Problem) is Electrical, then (X2) equal to zero (X3) (X3) (X1) (X1) Plumbing Plumbing Plumbing Plumbing Electrical Electrical Plumbing Plumbing Electrical Sam 13 0 0 0 23 23 23 28 28 Bob Bob Bob Sam am Sam Bob Sam 5.5 if (employee) is Sam, then (X3) equal to one if (employee) is Bob, then (X3) equal to zero. 23 23 23 28 28 0 0 7.9 5.9 7.7 7.9 5.9 7.7 0 0 8.9 8.9 43 SUMMARY OUTPUT Multiple R R Square Adjusted R Square Standard Error Observations 0.825459432 0.681383275 0.522074912 1.052106271 ANOVA MS ance F Regression Residual Total 3 14.203434364.73447812 4.27713 0.06168 6 6.6415656391.106927607 20.845 95%ower 950 95.0% 6.574367856 1.378832071 4.768070018 0.0031 3.20049 9.94825 3.200499.94824839 Days since last serv 0.058919293 0.043784583 1.345662996 0.22703 -0.04822 0.16606 -0.04822 0.166056309 Problem type (X2) 572428126 0.8454318141.859911231 0.11224 -3.64113 0.49627 -3.64113 0.496268999 0.142812608 0.697811429 0.204657881 0.84461 -1.8503 1.56467 -1.8503 1.564670446 Coefficients Standard Error t Stat P-value Lower 95% Intercept X3

Explanation / Answer

(a)

The coefficient for the variable - Employee (X3) is negative. X3 is equal to 1 when the employee is Sam and 0 when the employee is Bob.

Hence, Bob takes more time to repair and by 0.1428 hours

(b)

The p- value of the overall test is 0.06168

The level of significance = 0.10 is higher than the p - value of the test

Hence, the overall test is significant at level of significance = 0.10

(c)

The variables which explain the most to the least of the repair time (based on lowest to highest p - values of these variables) are:

Problem type

Days since last service

Employee

(d)

For the response variable - repair time,

mean = 6.95

standard deviation = 3.043755

So, based on 2 standard deviations rule, the range of the response variable

is = 3.906 to 9.994

All the values in the data set are within this range.

Hence, there are no outliers in the data set.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.