Purchase Solution

Forecasting of a Time Series, using Excel

Not what you're looking for?

Ask Custom Question

For this case study we will consider a company that sells cars (Car Dealer). The goal is to decompose the seasonality of the data represented by car sales. Data were collected quarterly for a period of 3 years. Thus, being quarterly data we will consider a moving average of order 4, and for the centering of the moving average we will consider a moving average of order 2.

The attachment includes a table of the data used.

Attachments
Purchase this Solution
Solution Summary

This Case Study reveals the seasonal decomposition method of a time series. The calculations were performed in EXCEL.

Solution provided by:
Chris Busu, PhD (IP)
Education
  • BSc, University of Bucharest
  • MSc, Ovidius
  • MSc, Stony Brook
  • PhD (IP), Stony Brook
Recent Feedback
  • "Thank you "
  • "Thank You Chris this draft really helped me understand correlation."
  • "Thanks for the prompt return. Going into the last meeting tonight before submission. "
  • "Thank you for your promptness and great work. This will serve as a great guideline to assist with the completion of our project."
  • "Thanks for the product. It is an excellent guideline for the group. "
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

  • Smoothing Techniques

    Here I give an example of using forecasting techniques to model this time series data: The basic time series forecasting model is the ARIMA model.

  • quantitative forecasting

    B) Construct a time series scatter plot. Is there an apparent trend component? (plug data into Excel, create simple scatter plot) C) Using an appropriate forecasting tool, predict the value for the next period of time.

  • A Discussion On Forecasting: Time Series

    5340 A Discussion On Forecasting: Time Series The table attached presents 4 years of quarterly sales for Mary's Mongoose Menagerie. Marty wants to know what quarterly sales will be in 2002. Project quarterly sales for 2002 using trend analysis.

  • Seasonal Forescasting in Excel

    This solution contains a detailed explanation of using Excel to do Seasonal Forescasting

  • Applied Quantitative Medthods and Forecasting Using Extrapolation By Moving Averages and Smoothing

    Some additional notes: ----------------------------- Time-series forecasting simply tries to predict a future sequence of values based on what has already happened.

  • Time Series & Forecasting

    This solution answers questions regarding time series and forecasting.

  • Forecasting of Time Series Data

    228068 Forecasting of Time Series Data The monthly number of permits granted for building houses in a large city is seasonal (there tend to be more permits granted for construction during spring and summer months than during winter months).

  • Regression Analysis

    You will learn about time series methods, such as the moving average, exponential smoothing, and linear trend line and, regression, which is used for forecasting by establishing a mathematical relationship between two or more variables.

  • problems for time series forecast using different models

    (a) Use these data to develop forecasts for the years 1992 through 2000 using a 4-year moving average. (b) Use these data to develop forecasts for the years 1992 through 2000 using a 4-year weighted moving average.

View More Related Solutions