Below is the data she gives you for the past 12 months, and then she asks, "How many customer service staff positions would you forecast we need in the next 6 months?"

Year 1 - # of customer service calls received. The online sales office is open from 7 am to 7 pm, 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.a. Using Excel, create a linear regression equation to model the number of calls per month.b. At the current rate of growth, how many customer service calls does the regression equation predict for June of year 2?c. 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?

Transcribed Image Text:

Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average # of customer service calls received per day for each month the center was open in year 1 37 28 42 48 63175 74 88 93 95 102 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average # of customer service calls received per day for each month the center was open in year 1 37 28 42 48 63175 74 88 93 95 102

Answer rating: 100% (QA)

Let the linear regression Equation be y a bx where y Dependent variableAverage No of customer service calls for each day of the month x Independent va... View the full answer