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

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.