Shown here are the consumer price indexes (CPIs) for housing for the years 1990 through 2011 from the Bureau of Labor Statistics Data Web site. Use the data to answer the following questions.
a. Compute the 4-year moving average to forecast the CPIs from 1994 through 2011.
b. Compute the 4-year weighted moving average to forecast the CPIs from 1994 through 2011. Weight the most recent year by 4,the next most recent year by 3, the next year by 2,and the last year of the four by 1.
c. Determine the errors for parts (a) and (b). Compute MSE for parts (a) and (b).Compare the MSE values and comment on the effectiveness of the moving average versus the weighted moving average for these data.

Transcribed Image Text:

Year Housing CPI Year Housing CPI 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 128.5 133.6 137.5 141.2 144.8 148.5 152.8 156.8 160.4 163.9 169.6 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 176.4 180.3 184.8 189.5 195.7 203.2 209.6 216.3 217.1 216.3 219.1