8. The manager of a diner wants to re-evaluate his staffing needs depending on variations in...

50.1K

Verified Solution

Question

Advance Math

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.

  1. What is the regression equation? Attach the Excel output.
  1. What is the predicted number of customers during the morningshifts?
  1. What is the predicted number of customers during the afternoonshifts?
  1. What is the predicted number of customers during the eveningshifts?
  1. What is the predicted number of customers during the nightshifts?

Answer & Explanation Solved by verified expert
3.9 Ratings (763 Votes)
IF YOU HAVE ANY DOUBTS COMMENT BELOW I WILL BE THERE TO HELP YOU ANSWER EXPLANATION data taken Customers Morning Afternoon Evening Night 99 0 0 0 1 148 0 1 0 0 130 0 1 0 0 106 0 0 0 1 133 0 0 0 1 119 0 0 0 1 105 1 0 0 0 74 1 0 0 0 106 0 0 0 1 94 0 1 0 0 69 0 0 1 0 86 0 0 1 0 95 1 0 0 0 99 0 1 0 0 71 0 0 1 0 80 0 0 1 0 63 0 0 1 0 93 0 0 0 1 117 1 0 0 0 136 0 1 0 0 91 0 0 1 0 131 0 0 0 1 112 0 1 0 0 88 1 0 0 0 59 0 0 1 0 44 0 0 1 0 129 0 0 0 1 82 0 0 1 0 78 0 0 0 1 109 1 0 0 0 51 0    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students