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.