1. a. . The annual percent change in the Dow Jones Industrial average, from 1960 through 1999 Develop spreadsheet models for forecasting each of the variables using Naive Method, 2-period Moving Average 4-period Moving Average 3-periods Weighted Moving Average (a, = 0.55, az = 0.35 and az = 0.10) Exponential Smoothing Trend Adjusted Exponential Smoothing Define the optimum smoothing coefficients, when necessary, for the DJ Index. (You might consider using data tables to facilitate your search) Using MAD, MSE, and MAPE find the best the method. b. c. Year Year 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 Percentage Change in DJ Index -9.34 18.71 -10.81 17 14.57 10.88 -18.94 15.2 4.27 -15.19 4.82 6.11 14.58 -16.58 -27.57 38.32 17.86 -17.27 -3.15 4.19 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 Percentage Change in DJ Index 14.93 -9.23 19.6 20.27 -3.74 27.66 22.58 2.26 11.85 26.96 -4.34 20.32 4.17 13.72 2.14 33.45 26.01 22.64 16.1 25.22