Explore BrainMass

Explore BrainMass

    Time Series for Apple, Inc

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:12 am ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/time-series-apple-inc-446371

    Attachments

    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 ...

    Solution Summary

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

    $2.19

    ADVERTISEMENT