Purchase Solution

Time Series Analysis

Not what you're looking for?

Ask Custom Question

Using some historical data for the past 40 periods (see attachment) I need to make a forecast for the next 12 periods (periods 41 thru 52) using whatever is the best/most accurate of the simple forecasting techniques we have covered so far in our 2nd year class.

These include:

1)Simple Moving Average
2)Weighted Moving Average
3)Exponential Smoothing
4)Linear Regression
5)Seasonal Forecasting via Regression, if we determine it is subject to seasonality (i.e., linear trends with multiplicative seasonality or nonlinear trends with multiplicative seasonality, and linear trends with additive seasonality or nonlinear trends with additive seasonality)

We need to investigate at least three differnt ways to forecast this data, and present the MAD (mean absolute deivaiton) and parameter values of each technique we tried. And state why we ended up going with a particular method as the most accurate.

I do not know how to do this. Can you help?

Attachments
Purchase this Solution
Solution Summary

Using some historical data for the past 40 periods (see attachment) I need to make a forecast for the next 12 periods (periods 41 thru 52) using whatever is the best/most accurate of the simple forecasting techniques we have covered so far in our 2nd year class.

These include:

1)Simple Moving Average
2)Weighted Moving Average
3)Exponential Smoothing
4)Linear Regression
5)Seasonal Forecasting via Regression, if we determine it is subject to seasonality (i.e., linear trends with multiplicative seasonality or nonlinear trends with multiplicative seasonality, and linear trends with additive seasonality or nonlinear trends with additive seasonality)

We need to investigate at least three different ways to forecast this data, and present the MAD (mean absolute deivation) and parameter values of each technique we tried. And state why we ended up going with a particular method as the most accurate.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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

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.

  • Multiple Choice Questions : Time Series Analysis

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

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

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

  • 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

  • Time Series Analysis and Random Processes

    450881 Time Series Analysis and Random Processes Question 1: Simulate a completely random process of length 48 with independent, normal values. Plot the time series plot. Does it look "random"?

View More Related Solutions