Purchase Solution

Time Series Analysis and Forecast

Not what you're looking for?

Ask Custom Question

Consider the airline ticket data in the file P13_01.xlsx.

a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think should be used for forecasting? Why?

b. Use simple exponential smoothing to forecast these data, using no holdout period and requesting 12 months of future forecasts. Use the default smoothing constant of 0.1.

c. Repeat part b, optimizing the smoothing constant. Does it make much of an improvement?

d. Write a short report to summarize your results.

PLEASE INCLUDE A DETAILED SUMMARY.

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of detailed analysis and step-by-step calculations of various Forecast Techniques like Exponentially Smoothed Forecast, Optimization of Smoothing Constant etc. in EXCEL. The solution provides students with a clear perspective of the given problems and the related aspects of forecast analysis.

Solution Preview

Please refer to the attachments.

Time Series Analysis Chart - shows a periodically increasing and decreasing pattern in the data set. When this data is plotted month-wise, in Time Series Analysis Chart - II, a single regular distribution pattern in the data is observed for each of the four years. Thus, we conclude that the data exhibits a ...

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

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

  • Compare and contrast forecasting methods

    The self-projecting time series uses only the time series data of the activity to be forecast to generate forecasts.

  • Time Series

    11416 Time series Horace Mann, principal of Jones Public School, has decided to construct a time series model to obtain a 2- and a 3-period moving average to forecast student enrollments for next term.

  • Time Series Data

    13011 Time series data Horace Mann, principal of Jones Public School, has decided to construct a time series model to obtain a 2- and a 3-period moving average to forecast student enrollments for next term.

  • Multiple Choice Questions : Time Series Analysis

    115615 Multiple choice question from time series analysis 1. Time series methods a. discover a pattern in historical data and project it into the future. b. include cause-effect relationships.

  • 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 forecasting problem

    122259 Time series forecasting problem Problem (see attached file) we are going time series techniques to predict non-retail sales for the next three months. Use the data in the file non retail time series for these exercises. 1.

  • Seasonal forecasting

    We have only covered the following topics so far: 1) Time series analysis: SimpleMovingAverage, Weightedmovingaverage, Exponential Smoothing 2) Differencing 3) Forecast errors: absolute deviation, mean absolute deviation (MAD), and tracking signal

  • 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

  • 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

View More Related Solutions