The yield on a 30-year treasury note at the end of each year since 1990 is recorded below. Compute a five-year weighted moving average using weights of .1, .1, .2, .3, and .3, respectively. Describe the trend in yield.
1990 8.61
1991 8.14
1992 7.67
1993 6.59
1994 7.37
1995 6.88
1996 6.71
1997 6.61
1998 5.58
1999 5.87
2000 5.94
2001 5.49
2002 5.43
Take weighted average of consecutive five year and place it against the centre year.
The calculations are in ans.xl file
COMMENT FROM STUDENT:
I noticed there isn’t a formula answer for …
Trend using moving averages.