Purchase Solution

Time series analysis: Linear trend

Not what you're looking for?

Ask Custom Question

Fit a linear trend equation to the following data describing average hourly earnings of US production workers. What is the trend estimate for 2010?

Year: 2001 2002 2003 2004
Average
Hourly
Earnings: $14.53 $14.95 $15.35 $15.67

2.

The following date show residential and commercial natural gas consumption (quadrillion Btu) from 1985 throught 2000.

Year Consumption Year Consumption
1985 27.6 1993 30.6
1986 26.9 1994 30.8
1987 27.6 1995 31.6
1988 28.9 1996 33.0
1989 29.4 1997 33.
1990 29.2 1998 32.8
1991 30.1 1999 35.8
1992 29.6 2000 37.4

A. Construct a graph of the time series, then superimpose a three-year centered moving average over the original series.
B. Superimpose a five-year centered moving average over the original series. Why is the moving average "smoother" when N = 5?

Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of linear trend . Formula for the calculation and Interpretations of the results are also included.

Purchase this Solution
Free BrainMass Quizzes
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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting Corporate Triple A Bond

    Graph this time series. Does a linear trend appear? b. Develop a linear trend equation for this time series. c. Use the trend equation to estimate the rating for the 2001-2002 season.

  • Linear Trend Forecast Analysis

    653185 Linear Trend Forecast Analysis For the time series below a) Develop a linear trend forecast b) Add a quadratic component to the model in part (a) and develop a new forecast c) Now assume a seasonal pattern and add

  • Time Series Analysis

    The linear trend forecasting equation for an annual time series containing 40 observations (from 1963 to 2002) on real net sales (in billions of constant 1995 dollars) is Y = 1.2 + 0.5X What is the fitted trend value for this time series on real net

  • Multiple Choice questions on time series analysis

    Linear trend equation c. Logarithmic trend equation d. Time series e. None of the above 29. Given a linear time series trend, Y' = 5.2 + 3.1t, what is the forecast for 2002 if the time series started in 1995?

  • Time Series Analysis: MCQs & Short Problems

    Question 10 Which of the following time-series forecasting methods would not be used to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns?

  • Time series analysis

    189027 Time Series Trend Analysis 1. Below is data regarding the growth of Spirit Airlines (1998 - 2002). Please answer the following questions: a. Chose one time-series describing Spirit Airlines and make a line chart. b.

  • Predicting forecast based on given trend line equation

    120414 Predicting forecast based on given trend line equation The following time series data represent the yearly amounts spent on advertising (in millions of dollars) by a large toy company: 23.3, 21.7, 22.7, 25.5, 22.7, 25.9 This series of data

  • Forecasting with Linear Trend

    THE LINEAR TREND EQUATION: (Wrong Trend equation) T = 34 + 15.345 t where T = trend value of the time series in period t TIME PERIOD TIME SERIES VALUE FORECAST FORECAST ERROR 1 63 49.35 13.66 2 58 64.69 -3.31

  • Few questions on forecasting models

    THE LINEAR TREND EQUATION: T = 24 + 15.345 t where T = trend value of the time series in period t TIME PERIOD TIME SERIES VALUE FORECAST FORECAST ERROR 3 63 39.35 43.66 2 58 54.69 3.31 1 61 70.04 -9.03 4

  • Time Series Analysis of US Online Advertising Spending

    174325 Time-Series Analysis in Excel Make an Excel graph of the data on U.S. online advertising spending. (b) Discuss the underlying causes that might explain the trend or pattern.

View More Related Solutions