FIND OUT THE 5 DAY MOVING AVERAGE AND COMPLETE THE SPREADSHEET Plug in the formulas in green cells N=5 Moving Average Forecasting Forecast Error MAD = Quarter Q4 Q3 Q2 Q1 Q4 Q3 02 Q1 Q4 Q3 Q2 Q1 Q4 Q3 Q2 Q1 Q4 Q3 Q2 Q1 Q4 Q3 Q2 Q1 Year 2016 2016 2016 2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012 2011 2011 2011 2011 Independent (NYSE) 3.13% 2.21% 2.77% 0.63% 3.51% -9.31% -0.86% 0.55% 1.27% -2.52% 4.29% 1.23% 8.10% 5.58% 0.06% 7.86% 2.33% 5.76% 4.94% 9.76% 10.09% -18.36% -1.02% 5.54% PRORROR FIND OUT THE 5 DAY MOVING AVERAGE AND COMPLETE THE SPREADSHEET Plug in the formulas in green cells N=5 Moving Average Forecasting Forecast Error MAD = Quarter Q4 Q3 Q2 Q1 Q4 Q3 02 Q1 Q4 Q3 Q2 Q1 Q4 Q3 Q2 Q1 Q4 Q3 Q2 Q1 Q4 Q3 Q2 Q1 Year 2016 2016 2016 2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012 2011 2011 2011 2011 Independent (NYSE) 3.13% 2.21% 2.77% 0.63% 3.51% -9.31% -0.86% 0.55% 1.27% -2.52% 4.29% 1.23% 8.10% 5.58% 0.06% 7.86% 2.33% 5.76% 4.94% 9.76% 10.09% -18.36% -1.02% 5.54% PRORROR