Explore BrainMass

Explore BrainMass

    Tim-Series Data - Weighted Moving Average

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 12:56 am ad1c9bdddf

    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. The yield on a 30-year treasury note at the end of each year are determined.