Regression & Time Series Analysis
Not what you're looking for?
The problem set has been attached. It has to do with Regression and forecasting.
Create a graph of Sales over this time period (Quarter 1 of 1986 through Quarter 1 of 2001)
What do you see happening to Coca Cola sales over this time period?
Run a simple linear regression of Sales on Time Period (recode the time period variable to be period 1-61).
Write the regression equation
Explain what the coefficient on Time tells you
Use this regression output to make a sales forecast for the time period below, if you assume that seasonality and time trends are additive.
Forecasted Sales for Quarter 3 of 2002 =
Use this regression output to make a sale forecast for the time period below, if you assume that seasonality and time trends are multiplicative.
Forecasted Sales for Quarter 3 of 2002 =
Run a multiple linear regression of Sales on Time Period and Season (where season is capture in dummy variables for each quarter). Include variables for quarters 1, 2 and 3 in your regression (so quarter 4 is your reference group).
Write the regression equation
Explain what the coefficients tell you.
The coefficient on time tells me that
The coefficient on Quarter 1 tells me that
The coefficient on Quarter 2 tells me that
The coefficient on Quarter 3 tells me that
Use this regression output to make a sales forecast for the time period below.
Forecasted Sales for Quarter 3 of 2002 =
Now run a multiple linear regression of Sales on Time Period and Season (where season is capture in dummy variables for each quarter). Include variables for quarters 1, 2 and 4 in your regression (so quarter 3 is your reference group).
Use this regression output to make a sales forecast for the time period below.
Forecasted Sales for Quarter 3 of 2002 =
Data set
Coca Cola quarterly sales
Quarter Sales
Q1-86 1734.83
Q2-86 2244.96
Q3-86 2533.80
Q4-86 2154.96
Q1-87 1547.82
Q2-87 2104.41
Q3-87 2014.36
Q4-87 1991.75
Q1-88 1869.05
Q2-88 2313.63
Q3-88 2128.32
Q4-88 2026.83
Q1-89 1910.60
Q2-89 2331.16
Q3-89 2206.55
Q4-89 2173.97
Q1-90 2148.28
Q2-90 2739.31
Q3-90 2792.75
Q4-90 2556.01
Q1-91 2480.97
Q2-91 3039.52
Q3-91 3172.12
Q4-91 2879.00
Q1-92 2772.00
Q2-92 3550.00
Q3-92 3508.00
Q4-92 3243.86
Q1-93 3056.00
Q2-93 3899.00
Q3-93 3629.00
Q4-93 3373.00
Q1-94 3352.00
Q2-94 4342.00
Q3-94 4461.00
Q4-94 4017.00
Q1-95 3854.00
Q2-95 4936.00
Q3-95 4895.00
Q4-95 4333.00
Q1-96 4194.00
Q2-96 5253.00
Q3-96 4656.00
Q4-96 4443.00
Q1-97 4138.00
Q2-97 5075.00
Q3-97 4954.00
Q4-97 4701.00
Q1-98 4457.00
Q2-98 5151.00
Q3-98 4747.00
Q4-98 4458.00
Q1-99 4428.00
Q2-99 5379.00
Q3-99 5195.00
Q4-99 4803.00
Q1-00 4391.00
Q2-00 5621.00
Q3-00 5543.00
Q4-00 4903.00
Q1-01 4479.00
Purchase this Solution
Solution Summary
The solution provides step by step method for the calculation of regression analysis and trend for a time series model. Formula for the calculation and Interpretations of the results are also included.
Solution Preview
Please see the attachments.
If you have any doubt, please don't hesitate to contact me.
Create a graph of Sales over this time period (Quarter 1 of 1986 through Quarter 1 of 2001)
What do you see happening to Coca Cola sales over this time period?
The time series plot suggests that there is upward trend in the sales. The graph also indicates the presence of regular systematic variation.
Run a simple linear regression of Sales on Time Period (recode the time period variable to be period 1-61).
Coefficients Standard Error t Stat P-value
Intercept 1603.817 108.8358 14.73612 1.96E-21
T 63.16868 3.052805 20.69202 9.9E-29
Write the regression equation
Sales = 1603.817 +63.16868 * Time
Explain what the coefficient on Time tells you
The regression coefficient of time suggest that for a unit increase in time, the sales increase by 63.16868 units
Use this regression output to make a sales ...
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.