Please see the attached Forecasting HW Needed. All Data are in the attachment

The next tab of this Excel spreadsheet contains the NFL raw data for these problems. In the National Football League, the philosophy for winning (rushing, passing, defense) seems to go through cycles. Consider a time series of the average number of rushing yards in the NFL per regular season from 1980 to 2008. 1) Make a time series plot. Is there evidence that the average rushing yards is trending in one direction? Describe the general movement of the series. 2) Fit a first order autoregressive model [AR(1)] using y(t) as the response variable and y (t-1) as the input variable. Record the regression equation. 3) Based on the AR(1) model, forecast the average number of rushing yards in the NFL for the 2009 regular season. 4) Calculate the exponential smoothing models using Excel damping factors 0.8 and 0.2 For each of the exponential smoothing models forecast the average number of rushing yards in the NFL for the 2009 season. 5) Calculate a moving average model using k=5 (Excel interval). Forecast the average number of rushing yards in the NFL for the 2009 season. e problems. NFL data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Year (x) Rushing yards/Game (y) 1980 127.5 1981 130.1 1982 117.8 1983 129.7 1984 123.9 1985 124.9 1986 118.7 1987 123.9 1988 121.4 1989 115.3 1990 113.9 1991 107.7 1992 110.5 1993 110 1994 104.3 1995 108.1 1996 109 1997 113 1998 112.7 1999 106.5 2000 112.6 2001 111.8 2002 116.1 2003 117.9 2004 116.6 2005 112.5 2006 117.3 2007 110.9 2008 114.6