Explore BrainMass
Share

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

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

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