Explore BrainMass

Tim-Series Data - Weighted Moving Average

I need to know why weighting is useful in calculating moving average and how it is calculated. The "how" I already have in technical terms, but I need it explained to me in laymen's terms.

Also, I need help with the following:

The yield on a 30-year treasury note at the end of each year since 1990 is recorded below. Compute a five-year (1) moving average and (2) weighted moving average using weights of .1, .1, .2, .3, and .3, respectively. Describe the trend in yield both in both narrative and graphical form.

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.

Solution Preview

Please see the attached Excel sheet.

A moving average is just a time series showing the average value of some number of previous points. It is like a "tail" that keeps following the data as it moves. In this problem, we're asked for two types of 5-year moving averages. For each year, both averages take in the data from the 5 most recent years ...

Solution Summary

The solution determines the weighted moving average.