Month Average # of customer service Calls received per day for each month the center was open in year one Month Jan 25 1 Feb 19 2 Mar 28 3 Apr 32 4 May 42 5 Jun 47 6 Jul 50 7 Aug 49 8 Sep 52 9 Oct 54 10 Nov 53 Dec 59 11 12 a. Using Excel, create a linear regression equation to model the number of calls per month. b. c. At the current rate of growth, how many customer service calls does the regression equation predict for June of year 2? Given your prediction for June of year 2, how many customer service staff members do you forecast will be needed per 12 hour shift to handle the load? Submit your findings in a Word document and include the Excel spread sheet. B. Y = a + bx New Totals Y=a+b13 Y=a+b14 Y=a+b15 Y=a+b16 Y=a+b17 Y=a+b18 C. This can be in a word document or on the excel Year 1 - # of customer service calls received. The online sales office is open from 7am to 7pm, seven days a week, and customer service staff work the entire 12-hour shift. You can assume a single call takes 15 minutes for a customer service rep to handle. B. Y = a + bx Y=a+b13 Y=a+b14 Y=a+b15 Y=a+b16 New Totals Y=a+b17 Y=a+b18 C. This can be in a word document or on the excel Year 1 - # of customer service calls received. The online sales office is open from 7am to 7pm, seven days a week, and customer service staff work the entire 12-hour shift. You can assume a single call takes 15 minutes for a customer service rep to handle. | 24.545 +6.6853(18)=145 calls per day on average. At 145 calls per day, that is 12 calls on average per hour. One person can handle 4 call a hour = how many people 145calls/12 hours 12.08