19 A B C D E F G H 1 L M N Month Average # of customer service Calls received per day for each month the center was open in 1 year one Month 2 Jan 25 1 3 Feb 2 4 Mar 28 3 5 Apr 32 4 6 May 42 5 7 Jun 47 6 8 Jul 50 7 9 49 8 10 Sep 52 9 11 Oct 54 10 12 Nov 53 11 13 Dec 59 12 14 15 a. Using Excel, create a linear regression equation to model the number of calls per month. 16 b. At the current rate of growth, how many customer service calls does the regression equation predict for June of year 2? 17 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? 18 Submit your findings in a Word document and include the Excel spread sheet. Aug c. 21 B. 22 Y = a + bx 23 New Totals 24 Y= a+b13 25 Y=a+b14 26 Y=a+b15 27 Y=a+b16 28 Y=a+b17 29 Y=a+b18 30 31 C. This can be in a word document or on the excel 32 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. 33 34 24.545 +6.6853(18) = 145 calls per day on average. 35 36 At 145 calls per day, that is 12 calls on average per hour. 145calls/ 12 hours =12.08 37 One person can handle 4 call a hour = how many people 38 39