Explore BrainMass

Explore BrainMass

    Time series & Regression analysis

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

    Part A Scatter plot

    1) Does it look linear?

    Part B Regression Analysis

    1.) What is the regression equation?

    2.) What are the predictions for 2006 and 2007?

    Part C Working file

    1.) Attach the document with the calculations

    --------------------------------------------------------------------------------

    INSTRUCTIONS

    MegaStat Users
    A. Create a scatterplot in MegaStat for t vs. Sales (select Markers and Lines).

    B. Run the regression analysis making predictions for 2006 and 2007.
    + Specify Durbin-Watson calculation.

    --------------------------------------------------------------------------------

    Non MegaStat Users
    A. Create a XY (Scatter) in Chart for t vs. Sales

    B. Run the regression analysis to make predictions for 2006 and 2007.
    + X = t
    + Y = Sales
    + Create a regression equation
    + Substitute X = 15 and calculate predicted Sales value.
    + Substitute X = 16 and calculate predicted Sales value.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:23 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/time-series-regression-analysis-228336

    Solution Summary

    The solution provides step by step method for the calculation of time series and regression model for a given set of data . Formula for the calculation and Interpretations of the results are also included.

    $2.19

    ADVERTISEMENT