A large call center is open customer service calls five days a week. The daily c

Question

A large call center is open customer service calls five days a week. The daily call volume data for the is given in the below output

Develop the regression equation for forecasts using the additive model.

Using the regression equation find forecasts for each day of the next week.

t Week Day Calls 1 1 1 1961 2 1 2 2473 3 1 3 2542 4 1 4 4997 5 1 5 3811 6 2 1 3495 7 2 2 3656 8 2 3 4527 9 2 4 5472 10 2 5 3435 11 3 1 2961 12 3 2 3943 13 3 3 4444 14 3 4 5784 15 3 5 5325 16 4 1 3708 17 4 2 5272 18 4 3 4616 19 4 4 5040 20 4 5 5018 21 5 1 4995 22 5 2 4674 23 5 3 6956 24 5 4 6093 25 5 5 4998 26 6 1 6663 27 6 2 6817 28 6 3 7252 29 6 4 7048 30 6 5 7162 31 7 1 5564 32 7 2 7675 33 7 3 6802 34 7 4 7977 35 7 5 7627

Explanation / Answer

Regression equation= Y = 137.7*X + 2686

For Forecasting each day of First week we put X=1,2,3,4,5,6,7 in the regression equation and get Y

For X=1 ,Y = 2823.7

For X=2 ,Y=2961.4

For X=3, Y=3099.1

For X=4 , Y=3236.8

For X=5 ,Y=3374.5

For X=6 , Y=3512.2

For X=7 , Y= 3649.9

For Forecasting each day of the next week after 7th week i.e. 8th week we put X= 36,37,38,39,40,41,42

For X = 36 , Y = 7643.2

For X = 37 , Y= 7780.9

For X= 38 , Y =7918.6

For X = 39 , Y=8056.3

For X=40 , Y= 8194.0

For X = 41 , Y = 8331.7

For X = 42 , Y =8469.4

Best-fit values Slope 137.7 ± 13.41 Y-intercept 2686 ± 276.7 X-intercept -19.50 1/Slope 0.007260 95% Confidence Intervals Slope 110.5 to 165.0 Y-intercept 2123 to 3249 X-intercept -29.03 to -13.03 Goodness of Fit R square 0.7619

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.