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):

Average Estimation Error of the Linear Regression model (Question 3b). Explain the difference between these two values.

Average Estimation Error for Causal Forecasting model based on headcount: __________________

Please share step by step instructions: