Purchase Solution

Time series analysis

Not what you're looking for?

Ask Custom Question

1. Below is data regarding the growth of Spirit Airlines (1998 - 2002). Please answer the following questions:
a. Chose 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.

Year Revenue Aircraft Full-time Employees
1998 131 14 860
1999 227 20 1440
2000 311 24 1729
2001 354 27 2094
2002 403 28 2345

2. Please answer the following questions regarding fuel economy using the data below:
a. Plot all four time series on fuel efficiency on the same graph.
b. Fit a linear trend to each.
c. Interpret each fitted trend equation, explaining its implications.
d. Based on the fit statistic given in the output (R2), which line fits the data most closely?
e. Calculate a trailing moving average and a centered moving average on the passenger car column of data.

Existing Vehicles New Vehicles
Year Passenger car Other Vehicles Car Light Truck
1990 20.3 16.1 28.0 20.8
1991 21.2 17.0 28.4 21.3
1992 21.0 17.3 27.9 20.8
1993 20.6 17.4 28.4 21.0
1994 20.8 17.3 28.3 20.8
1995 21.1 17.3 28.6 20.5
1996 21.2 17.2 28.5 20.8
1997 21.5 17.2 28.7 20.6
1998 21.6 17.2 28.8 21.1
1999 21.4 17.0 28.3 20.9
2000 21.9 17.4 28.5 21.3
2001 22.1 17.6 28.6 20.9

Attachments
Purchase this Solution
Solution Summary

Step by step method for estimating trend from a time series is in the answer.

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

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

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.

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