1. use a 2-year moving average method to calculate forecasts for the years 1992-2002

2. use a 2-year weighted moving average methid to calculate the forcasts for years 1992-2002, with the weight of 0.7 to be assigned to the most recent year data.

(you could use the SUMPRODUCT function to smplify computation)

3. calculate the forecasts for the years 1990-2002 using exponential smoothing method with alpha = 0.8

4. calculate the forecasts for years 1990-2002 using the linear line.

industry over a twelve-year period. Year 1990 1991 1992 1993 1994 1995 Merger 46 46 62 45 64 61 Year 1996 1997 1998 1999 2000 2001 Merger 83 123 97 186 225 240