Answer Happy

Open the winev9 MP file and see that it has yearly wine consumption data in millions of liters. Perform (1) naive forecasting: (2) simple average forecasting: (3) moving average forecasting of order 3; and (4) exponential smoothing forecasting using alpha=0.5 and the forecast value for Year 2001 - 1.486. Complete the following statements: 1. The naive forecast for Year 2013 is [Select] 2. The simple average forecast for Year 2013 is Select) 3. The moving average forecast of order 3 for Year 2013 is [ Select] 4. The exponential smoothing forecast using alpha=0.5 for Year 2013 is [Select] 5. The mean forecast error for the naive forecasting method is [Select 6. The mean absolute error for the moving average forecasting method is [Select] 7. Using mean forecast error as the forecasting metric, naive forecasting is the best method in this case (T/F) F 8. Using mean absolute error as the forecasting metric, exponential smoothing forecasting is the best method in this case (T/F) F

Tables Win Rows Cols DOE Analyze Graph Tools View E"> D. Year 1 2000 Wine -1.486 1.287 1.656 2001 N 3 2002 4 2003 2004 1.691 1.847 5 6 2005 1.977 2.141 7 2006 8 s (270) 2007 2008 9 10 2.29 2.007 2.157 2.499 2.246 2.433 2009 2010 2011 2012 11 12 13