Purchase Solution

Time series chart of airline data

Not what you're looking for?

Ask Custom Question

For this exercise, use Excel, MegaStat, or MINITAB to make an attractive, well-labeled time-series line chart. Adjust the Y-axis scale if necessary to show more detail (since Excel usually starts the scale at zero). If a fitted trend is called for, use Excel's option to display the equation and R2 statistic (or MAPE, MAD, and MSD in MINITAB). Include printed copies of all relevant graphs with your answers to each exercise.

14.10 (a) Choose one time-series describing Spirit Airlines and make a line chart.
(b) Describe the trend (if any) and discuss possible causes.
(c) Fit both a linear and an exponential trend to the data.
(d) Which model is preferred? Why?
(e) Make a forecast for 2003, using a trend model of your choice (or a judgment forecast).

Growth of Spirit Airlines, 1998-2002
Year Revenue ($ mil) Aircraft FT Employees
1998 131 14 860
1999 227 20 1,440
2000 311 24 1,729
2001 354 27 2,094
2002 403 28 2,345

Attachments
Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of time series model for airline data . 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

  • Time series forecasting problem:Airline data

    184366 Time Series Consider the airline ticket data in the attached file. 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.

  • Time Series Analysis and Forecast

    350260 Time Series Analysis and Forecast Consider the airline ticket data in the file P13_01.xlsx. a. Create a time series chart of the data.

  • Time Series & Forecasting

    This solution answers questions regarding time series and forecasting.

  • Time-series plot

    This solution constructs a time-series plot and evaluates the data patterns.

  • Problem analysis--time series

    [use Megastat, p-chart function]. B) Based on the above data, we can conclude that the postal delivery process is out of control? Please see the attached file. Problem analysis for time-series is given.

  • AirPassengers time series analysis with R

    Here we analyse time series data of air passengers in R by modelling as a combination of sinusoidal.

  • Patterns of Time Series Data

    65411 Patterns of Time Series Data What are the patterns of a time series data? As an applied statistician in business I am always confronted with data mining situations.

  • stacked column charts

    Highlight the headings and the data excluding the totals. Select series in rows for one question and columns for the other. Step 3: Click on the Series tab and verify that all of the information is correct.

  • Monthly Number of Airline Tickets Sold

    Which of the three spans appear to be more appropriate? Why? 7. Re-considering the airline ticket data, answer the following: a. Graph the time series data. Based on the graph of part a, which exponential smoothing model do you recommend? Why?

View More Related Solutions