Purchase Solution

Trend using moving averages

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution
Solution Summary

Trend using moving averages.

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

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Moving Average Forecasting Models

    Data can be obtained from the Internet by using the following keywords: stock price data, return data, company data, and stock returns. •Create trend-moving averages with the following values form: 10, 100, and 200. Graph the data with Excel.

  • Why is the trend commonly thought to be the most important c

    Why are simple moving averages and weighted averages commonly used forms of forecasting? Why is the trend commonly thought to be the most important component of forecasting?

  • The ABC Floral Shop sold the following number of geraniums d

    Moving averages lag because they are based on past prices. Despite this lag, moving averages help smooth price action and filter out the noise. Calculate a forecast of the above demand using a 3- and 5-period moving average.

  • Management Tools: Moving Average Forecasting Models

    -How do the moving averages for the same values of m compare between a trend-moving average and a centered-moving average? -How can these moving averages assist a stock analyst in determining the stocks' price direction?

  • Tim-Series Data - Weighted Moving Average

    Compute a five-year (1) moving average and (2) weighted moving average using weights of .1, .1, .2, .3, and .3, respectively.

  • Forecasting Corporate Triple A Bond

    Compute three- and four-quarter moving averages for this time series. Which moving average provides the better forecast for the fourth quarter of 2003? b.

  • Forecast personnel expenses for year 20X5

    moving averages, weighted moving averages, exponential smoothing, and time series regression.

  • Yield on a 30-year Treasury Note

    Regards kalpana Solution attaches a .doc file with a graph and calculations showing how to describe the yield trend of weighted moving averages.

  • Compariosn of forecasting methods

    78864 Forecasting:"Exponential smoothing", "Moving averages","Weighted moving average","Exponential smoothing with trend", (See attached file for full problem description) Your manager is trying to determine what forecasting method to use.

View More Related Solutions