Question
Please help me understand if I am doing this correctly. Please help me understand if I am correct in my work. I feel like the
Please help me understand if I am doing this correctly.
Please help me understand if I am correct in my work. I feel like the value should be higher. I am doubting myself. Please verify and explain step by step.
Question 3b (10 points): Apply Linear Regression to predict call volume from head count using the appropriate Excel template. Assume the headcount in July is 80000. Using this headcount number, show your forecast below and attach the completed Excel template. Call Volume Forecast for July 2015 (Causal Forecasting based on head count of 80,000):
Actual Employee Call Head Year Month Volume Count Forecast Notes SUMMARY OUTPUT 2014 Jan 24,015 62, 120 Formula N P 2014 Feb 25,203 62, 152 Intercept 43661.82 a Regression Statistics 2014 Mar 23,589 62, 138 Slope -0.25141 b Multiple R 0.189342196 4 2014 Apr 27,454 68,343 R Square 0.035850467 5 2014 May 28, 120 68, 120 Predicted call volume for July 23,549.32 Adjusted R Squar -0.020864211 6 2014 Jun 28,321 67,987 Standard Error 7011.252724 2014 Jul 29,021 67,956 Observations 19 CO 2014 Aug 26,954 65,342 9 2014 Sep 26,456 65,380 ANOVA 10 2014 Oct 27, 120 65,432 df SS MS F Significance F 11 2014 Nov 26,954 65,423 Regression 1 31073530 31073530 0.632119728 0.437539073 12 2014 Dec 27,321 65,650 Residual 17 8.36E+08 49157665 13 2015 Jan 26,456 65,620 Total 18 8.67E+08 14 2015 Feb 27,450 65,610 15 2015 Mar 31,435 75,231 Coefficients andard Err t Stat P-value Lower 95% Upper 95% 16 2015 Apr 33, 124 75,201 Intercept 43661.82409 21656.92 2.016068 0.059878155 -2030.275096 89353.9232 17 2015 May 32,432 74,978 X Variable 1 -0.251406269 0.316211 -0.79506 0.437539073 -0.918552328 0.4157397 18 2015 Jun 31,901 75,012 23,549.32 19 2015 Jul 0 80,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started