Purchase Solution

Time Series for Apple, Inc

Not what you're looking for?

Ask Custom Question

The required Apple Inc sales data in attached Excel document.

You will therefore be required to collect historical unadjusted (i.e. should not be adjusted for seasonality) data for eight years, that will be used for these time series.

TIME SERIES PARTICULARS

You must perform a complete time series analysis, making use of the following guidelines:

Double check that your data is NOT seasonally adjusted and that you have 8 years (must be either quarterly or monthly) of data in total.

Seasonal Variation

Trend Analysis

Based on the time series (original data) graph, describe the time series (i.e. before de-seasonalizing).
On the same graph as (a) graph the de-seasonalized time series.
Write out the Trend line equation provided by your computer (or manual) output and explain the meaning of the components (b0, b1) as they apply to your dependent variable. (De-seasonalize your data before finding the Trend Line).

Cyclical-Irregular variation

Forecasting

Show all detailed calculations.
Plot the actual and predicted values against time on the same graph.

Copy of the data.
Calculation of seasonal indices.
Calculation of Trend Line
Graph of original data and the trend line
Graph of Seasonal indices
Graph of Predicted and actual values vs. time.

Attachments
Purchase this Solution

Solution Summary

Step by step method for time series analysis is discussed here .

Solution Preview

Please see the attached files.

Time Series for Apple Inc
Need urgent help with Time Series. Will add 50% additional credits if this is done in one day. The required Apple Inc sales data in attached document.

"You will therefore be required to collect historical unadjusted (i.e. should not be adjusted for seasonality) data for eight years, that will be used for these time series

TIME SERIES PARTICULARS

You must perform a complete time series analysis, making use of the following guidelines:

Double check that your data is NOT seasonally adjusted and that you have 8 years (must be either quarterly or monthly) of data in total.

Seasonal Variation

Trend Analysis

Based on the time series (original data) graph, describe the time series (i.e. before de-seasonalizing).
On the same graph as (a) graph the de-seasonalized time series.
Write out the Trend line equation provided by your computer (or manual) output and explain the meaning of the components (b0, b1) as they apply to your dependent variable. (De-seasonalize your data before finding the Trend Line).

Cyclical-Irregular variation

Forecasting

Show all detailed calculations.
Plot the actual and predicted values against time on the same graph.

Copy of the data.
Calculation of seasonal indices.
Calculation of Trend Line
Graph of original data and the trend line
Graph of Seasonal indices
Graph of Predicted and actual values vs. time."

Calculation of seasonal index
Seasonal index are computed using ratio of moving average method.
Details
Centered Moving Average and De-seasonalization

Centered
Moving Ratio ...

Purchase this Solution


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

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.