Explore BrainMass

Time series & Regression analysis

This content was STOLEN 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



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 October 16, 2018, 10:39 pm ad1c9bdddf

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.

Similar Posting

Regression Analysis of Time Series Data

The following time series data represent the yearly amounts spent on advertising (in millions of dollars) by a large toy company:
33.3, 42.5, 44.9, 47.2, 48.7, 53.1, 46.1, 46.8, 55.2
This series of data begins in year (i.e., time period corresponds to 1994. Using regression analysis, a linear trend line of the form was fit to the data. Using this information, generate a forecast for the total yearly amount of money that will be spent on advertising in 1994 .

View Full Posting Details