Share
Explore BrainMass

Time series & Regression analysis

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.

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