8. The manager of a diner wants to re-evaluate his staffingneeds depending on variations in customer traffic during the day.He collects data on the number of customers served along with fourdummy variables representing the morning, afternoon, evening, andnight shifts. The dummy variable Morning equals 1 if theinformation was from the morning shift and 0 otherwise. The dummyvariable Afternoon equals 1 if the information was from theafternoon shift and 0 otherwise. The dummy variable Evening equals1 if the information was from the evening shift and 0 otherwise.The dummy variable Night equals 1 if the information was from thenight shift and 0 otherwise. Data is posted on Webcampus in excelfile titled Shifts Data.
Estimate a regression model using the number of customers as theresponse (dependent) variable and the shift dummy variables as theexplanatory (independent) variables.
- What is the regression equation? Attach the Excel output.
- What is the predicted number of customers during the morningshifts?
- What is the predicted number of customers during the afternoonshifts?
- What is the predicted number of customers during the eveningshifts?
- What is the predicted number of customers during the nightshifts?
