Analysis
a) Using regression as the procedure, produce the forecast of weekly sales for the periods Jan 27, 2014 through Jan 19, 2015
b) Show a graph of the historical and forecasted sales in one graph
c) Which week in the forecasted period is expected to have the highest volume of sales and which week is expected to have the lowest volume of sales
d) Using year-over-year change as the procedure, produce the forecast of weekly sales for the periods Jan 27, 2014 through Jan 19, 2015
e) Show a graph of the historical and forecasted sales in one graph
f) Which weeks in the forecasted period are expected to have the highest volume of sales and the lowest volume of sales
General
e) Does either of the forecasts "look" good to you? Why or why not?
f) What are the implications to a business if the forecast is too high?
g) What are the implications to a business if the forecast is too low?
h) Give three examples of of data that cannot be forecasted and why.
Attachment:- Forecasting.xlsx