A hospital emergency room analyzed n17665 hourly observation

A hospital emergency room analyzed n=17,665 hourly observations on its average occupancy rates using six binary predictor variables representing days of the week and two binary predictors representing the 8 hour work shift (12AM-8AM, 8AM-4PM, 4PM-12AM) when the ER census was taken. The fitted regression equation was AvgOccupancy = 11.2+1.19 Mon-.187 Tue-.785 Wed-.580 Thurs - .451 Fri - .267 Sat - 4.58 Shift1-1.65 Shift2 (R^2 = .094, R^2 Adj = .093) 1.Why did the analyst use only six binaries for days when there are 7 days in a week? 2. Why did the analyst use only two binaries for work shifts when there are actually 3? 3. Which day of the week is the busiest? 4. Which shift is the busiest? 5. Interpret the intercept term 6. Asses the regression\'s fit

Solution

AvgOccupancy = 11.2+1.19 Mon-.187 Tue-.785 Wed-.580 Thurs - .451 Fri - .267 Sat - 4.58 Shift1-1.65

1) The seventh variable will have all zeros on the first six variables

2) The third variable will have all zeros on the first two variables

3) Monday is the busiest as it has the highest coeffecient

4) Shift 2 is the busiest

5) It states that if there is no occupancy on the six days there will be an average occupancy of 11.2

6) It is not a good fit since R² is small and hence only 9% of the variance is being accounted for