Purchase Solution

Time series analysis

Not what you're looking for?

Ask Custom Question

DQ3:

(a) Name two advantages and two disadvantages of each of the common trend models (linear, exponential, quadratic). Explain!

(b) When would the exponential trend model be preferred to a linear trend model? Explain!

DQ4:

One of the methods that is used to moderate (smooth) the peaks and valleys within a time series, is known as the centered moving average method for smoothing a time series. This method smooth out the short-term fluctuations in the data, replacing the original times series with as new time series, where short-term seasonal and irregular variation are removed, leaving behind a combined trend and cyclical movement. The following is an exercise, where you are to perform the required calculations to develop typical seasonal pattern for a given time series data, using the centered to moving average method.

Problem Statement: The Appliance Center sells a variety of electronics equipments and home appliances. For last four years the following quarterly sales (in $ millions) were recorded.

Year Quarter
Winter Spring Summer Fall
2001 5.3 4.1 6.8 6.7
2002 4.8 3.8 5.6 6.8
2003 4.3 3.8 5.7 6.0
2004 5.6 4.6 6.4 5.9

a) Using Excel, plot the data on a chart (Please code the years, starting with code = 1 for 2001). Describe the overall long term pattern ( upward or downward movement of the time series over time)

b) Develop the typical seasonal pattern for Appliance Center Company, using the ratio-to-moving-average method. Explain the typical index for each season.

Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of trend for a time series model The solution also provides advantages and disadvantages of common trend models. Formula for the calculation and Interpretations of the results are also included.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

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

  • Compare and contrast forecasting methods

    Unlike most time-series forecasting techniques, the Trend Analysis does not assume the condition of equally spaced time series. Seasonal Index: Seasonality is a pattern that repeats for each period.

  • approaches to revenue forecasting.

    452093 Public Budgeting: Compare and contrast qualitative, time series, and causal analysis approaches to revenue forecasting. Compare and contrast qualitative, time series, and causal analysis approaches to revenue forecasting.

  • Time Series Forecast

    This solution is comprised of a detailed analysis of the given problem and step-by-step calculations in EXCEL and provides students with a clear perspective of the underlying concepts of Time Series Forecast Analysis.

  • Multiple Choice Questions : Time Series Analysis

    This solution provides answers to multiple choice question from time series analysis

  • Time Series and Forecasting

    Time series is one of the quantitative methods we use to determine patterns in data collected over time. Time series analysis is used to detect pattern of change in statistical information over regular intervals of time.

  • Multiple Regression & Time Series Forecasting

    446898 Multiple Regression & Time Series Forecasting The CEO noticed that he has five years of quarterly sales data in hand, and they form a time series.

  • Multiple regression and Time series analysis

    231394 Multiple Regression and Time Series Analysis Multiple Regression (a) What is a binary predictor? (b) How do we test a binary predictor for significance?

  • 3 examples of Time Series used by your organization

    Based on the previous years data, a time series analysis can be performed to predict the demand for this year so that adequate stocks can be maintained. 3.

  • Regression Analysis of Time Series Data

    228066 Regression Analysis of Time Series Data The following time series data represent the yearly amounts spent on advertising (in millions of dollars) by a large toy company: 33.3, 42.5, 44.9, 47.2, 48.7, 53.1, 46.1, 46.8, 55.2 This series of data

  • Patterns of Time Series Data

    Trend Analysis: There are no proven "automatic" techniques to identify trend components in the time series data; however, as long as the trend is monotonous (consistently increasing or decreasing) that part of data analysis is typically not very difficult

View More Related Solutions