Explore BrainMass

Explore BrainMass

    Trend using moving averages

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

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 6:39 pm ad1c9bdddf
    https://brainmass.com/statistics/central-tendency/trend-using-moving-averages-69549

    Solution Preview

    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 ...

    Solution Summary

    Trend using moving averages.

    $2.19

    ADVERTISEMENT