The following seasonal regression was fitted with quarterly seasonal binaries beginning in the first quarter (Qtr4...
The following seasonal regression was fitted with quarterly seasonal binaries beginning in the first quarter (Qtr4 is omitted to avoid multicollinearity). Make a prediction for y_t in period (a) t=21; (b) t=8; (c) t=15 yt=213+11t-9 Qtr1+12 Qtr-15 Qtr3
Homework Answers
yt=213+11t-9 Qtr1+12 Qtr2 -15 Qtr3
Using Qtr vlues as 0/1 for the corresponding quarters (Q1=1 for first quarter sales, when Q2/Q3/Q4 will be 0).
a) y21 = 213
The table below shows the calculations of sales per quarter of the year, coefficient of Q4 always being 0 as per the model:
| t | Qtr1 | Qtr2 | Qtr3 | Qtr4 | yt |
| 21 | 1 | 0 | 0 | 0 | 435 |
| 21 | 0 | 1 | 0 | 0 | 456 |
| 21 | 0 | 0 | 1 | 0 | 429 |
| 21 | 0 | 0 | 0 | 0 | 444 |
where yt is calculated using the regression equation above, plugging in the different values for Year/Qtr1/Qtr2/Qtr3/Qtr4 as per the year and quarter number.
b) Similarly, for t=8:
| t | Qtr1 | Qtr2 | Qtr3 | Qtr4 | yt |
| 8 | 1 | 0 | 0 | 0 | 292 |
| 8 | 0 | 1 | 0 | 0 | 313 |
| 8 | 0 | 0 | 1 | 0 | 286 |
| 8 | 0 | 0 | 0 | 0 | 301 |
c) Similarly for t=15:
| t | Qtr1 | Qtr2 | Qtr3 | Qtr4 | yt |
| 15 | 1 | 0 | 0 | 0 | 369 |
| 15 | 0 | 1 | 0 | 0 | 390 |
| 15 | 0 | 0 | 1 | 0 | 363 |
| 15 | 0 | 0 | 0 | 0 | 378 |
Add Answer to:
The following seasonal regression was fitted with quarterly
seasonal binaries beginning in the first quarter (Qtr4...
The following seasonal regression was fitted with quarterly seasonal binaries beginning in the fi...
The following seasonal regression was fitted with quarterly seasonal binaries beginning in the first quarter (Qtr4 is omitted to avoid multicollinearity). Make a prediction for y_t in period (a) t=21; (b) t=8; (c) t=15 yt=213+11t-9 Qtr1+12 Qtr-15 Qtr3
DATA ANALYTICS
Item 9Item 9 2 pointsCoca-Cola Revenues ($ millions), 2005–2010Quarter200520062007200820092010Qtr15,2045,1266,0857,4007,1708,000Qtr26,3086,4757,7159,0558,2288,663Qtr36,0356,4187,6728,3118,0358,415Qtr45,5495,9157,3137,0807,49210,483 Click here for the Excel Data File (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1234200520062007200820092010mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) Q1Q2Q3Q4 (a-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) yt = xt + (b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.) yt = + t + Q1...
2005 2006 2007 2008 2009 2010 6,5es 7,205 7.30 8,333 8.263 9,368 7,697 8,599 9,607 10,945 10.592 ...
2005 2006 2007 2008 2009 2010 6,5es 7,205 7.30 8,333 8.263 9,368 7,697 8,599 9,607 10,945 10.592 14.,801 Ctr3 8.184 8,950 10,171 11,244 11,080 15,514 Ctr4 10,096 10,383 12,346 2,729 13297 18,155 Click here for the Excel Data Fie (a-1) Use Megastat or MINTAB to deseasonalize Pepsico's quarterly data (Round your answers to 3 decimal places.) (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) Q3 04 (a-3) what is the trend model for the...
Coca-Cola Revenues ($ millions), 2005-2010 Quarter 2005 2006 2007 2008 Qtri 5,196 5,109 6,065 7,360 Qtr2...
Coca-Cola Revenues ($ millions), 2005-2010 Quarter 2005 2006 2007 2008 Qtri 5,196 5,109 6,065 7,360 Qtr2 6,300 6,455 7,695 9,035 Qtr3 6,027 6,402 7,652 8,299 Otr4 5,541 5,895 7,293 7,015 2009 2010 7,130 7,700 8,212 8,655 8,015 8,407 7,468 10,475 Click here for the Excel Data File (2-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 2 3 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes....
A regression model with quarterly seasonal dummy variables was fit to quarterly sales data (in $10.000)...
A regression model with quarterly seasonal dummy variables was fit to quarterly sales data (in $10.000) for a small company. The results are shown below. The dummy variables and other devede are defined as follows: Q1 = 1 if the time period is Quarter 1, and O otherwise. Q2 and 3 are defined similarly. Abbreviations Used in the Output • "R-So" stands for "r squared • "R-Sq" stands for "adjusted rsquared SSE • s stands for "regression standard error," equal...
Consider the following time series data. Consider the following time series data. Quarter Year 1 Year...
Consider the following time series data.
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
3
6
8
2
2
4
8
3
4
7
9
4
6
9
11
(a)
Choose the correct time series plot.
(i)
(ii)
(iii)
(iv)
- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item
1
What type of pattern exists in the data?
- Select your answer -Positive trend pattern, no
seasonalityHorizontal pattern, no seasonalityNegative trend
pattern, no seasonalityPositive...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8 10 2 1 3 7 3 3 6 8 4 7 10 12 (d) Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for Quarter 1 in Year 1, t =...
Please help I am very confused on how to solve this South Shore Construction builds permanent...
Please help I am very confused on how to
solve this
South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $315,000 in the first year of operation to $1,075,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars. Quarter Year 1 TE Year 2 Year 3 Year 4 Year 5...
video Consider the following time series. Quarter Year 2Year 3 Year 1 71 49 58 75 68 41 60 81 62 51 53 75 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePeriod(t) Time...
video Consider the following time series. Quarter Year 2Year 3 Year 1 71 49 58 75 68 41 60 81 62 51 53 75 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePeriod(t) TimeSeries Value O Type here to search otps/hg cengage.com/static/nb/uifevo/index.html?deploymentld-57360022185226012174 N-97813371153778id-429851674&snapsho NGAGE MINDTAP er 17 Assignment a. Choose a time series plot. TameSeries Value 60 40 20 24TimePeriod it) TimeSeries Value 60 40 20 TimeSeries Value 60 40 20 TimePeriodit) Time Period it 2 TimeSeries...
eBook Consider the following time series data. Quarter Year1 Year 2 Year 3 10 10 12...
eBook Consider the following time series data. Quarter Year1 Year 2 Year 3 10 10 12 Plot (i) What type of pattern exists in the data? Select your answer b) Use a multi le regression model with dummy variables as ollows to develop an equation to account or seasonal effects in the data tri . 1 if uarter 1 0 otherwise; tr2·1 i uarter 2 0 otherwise; tr3-1 if uarter 3 0 otherwise. If requred, round your answers to three...
2005 2006 2007 2008 2009 2010 6,5es 7,205 7.30 8,333 8.263 9,368 7,697 8,599 9,607 10,945 10.592 14.,801 Ctr3 8.184 8,950 10,171 11,244 11,080 15,514 Ctr4 10,096 10,383 12,346 2,729 13297 18,155 Click here for the Excel Data Fie (a-1) Use Megastat or MINTAB to deseasonalize Pepsico's quarterly data (Round your answers to 3 decimal places.) (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) Q3 04 (a-3) what is the trend model for the...
Coca-Cola Revenues ($ millions), 2005-2010 Quarter 2005 2006 2007 2008 Qtri 5,196 5,109 6,065 7,360 Qtr2 6,300 6,455 7,695 9,035 Qtr3 6,027 6,402 7,652 8,299 Otr4 5,541 5,895 7,293 7,015 2009 2010 7,130 7,700 8,212 8,655 8,015 8,407 7,468 10,475 Click here for the Excel Data File (2-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 2 3 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes....
A regression model with quarterly seasonal dummy variables was fit to quarterly sales data (in $10.000) for a small company. The results are shown below. The dummy variables and other devede are defined as follows: Q1 = 1 if the time period is Quarter 1, and O otherwise. Q2 and 3 are defined similarly. Abbreviations Used in the Output • "R-So" stands for "r squared • "R-Sq" stands for "adjusted rsquared SSE • s stands for "regression standard error," equal...
Consider the following time series data.
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
3
6
8
2
2
4
8
3
4
7
9
4
6
9
11
(a)
Choose the correct time series plot.
(i)
(ii)
(iii)
(iv)
- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item
1
What type of pattern exists in the data?
- Select your answer -Positive trend pattern, no
seasonalityHorizontal pattern, no seasonalityNegative trend
pattern, no seasonalityPositive...
Please help I am very confused on how to
solve this
South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $315,000 in the first year of operation to $1,075,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars. Quarter Year 1 TE Year 2 Year 3 Year 4 Year 5...
video Consider the following time series. Quarter Year 2Year 3 Year 1 71 49 58 75 68 41 60 81 62 51 53 75 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePeriod(t) TimeSeries Value O Type here to search otps/hg cengage.com/static/nb/uifevo/index.html?deploymentld-57360022185226012174 N-97813371153778id-429851674&snapsho NGAGE MINDTAP er 17 Assignment a. Choose a time series plot. TameSeries Value 60 40 20 24TimePeriod it) TimeSeries Value 60 40 20 TimeSeries Value 60 40 20 TimePeriodit) Time Period it 2 TimeSeries...
eBook Consider the following time series data. Quarter Year1 Year 2 Year 3 10 10 12 Plot (i) What type of pattern exists in the data? Select your answer b) Use a multi le regression model with dummy variables as ollows to develop an equation to account or seasonal effects in the data tri . 1 if uarter 1 0 otherwise; tr2·1 i uarter 2 0 otherwise; tr3-1 if uarter 3 0 otherwise. If requred, round your answers to three...
Most questions answered within 3 hours.
-
Write the ionic equations for the first stage of salts
hydrolysis.
Anion, Cation?
Na2S
NiSO4
K2SO4...
asked 1 hour ago -
suppose there is a normally distributed population with a mean of
250 and a standard deviation...
asked 1 hour ago -
Question Three
Suppose you as project manager are using the Waterfall
development methodology on a large...
asked 2 hours ago -
Which statement is not true about welfare in Canada?
A.Benefits typically vary based on one's ability...
asked 3 hours ago -
Please help me with FLOWCHART and UML diagram for class,
thank you!
#include <iostream>
#include <fstream>...
asked 4 hours ago -
3. Describe the “logic circuit” of the Lac operon. Which
proteins are bound or not to...
asked 4 hours ago -
Ayesha’s adjusted gross income is $60,000 in 2019. She donated a
piece of artwork with a...
asked 4 hours ago -
For Dijkstra’s shortest path algorithm:
a. Give the Big-O time for Dijkstra’s shortest path algorithm
and...
asked 4 hours ago -
Phosphorus violates the 'octet rule' in biological molecules,
forming more covalent bonds than expected based on...
asked 4 hours ago -
A 1.3 eV electron has a 10-4 probability of tunneling
through a 2.4 eV potential barrier....
asked 4 hours ago -
What is the one ingredient that is common to being successful
with all stakeholders?
profit
trust...
asked 4 hours ago -
Write an assembly language 32 bit program that reads in lines of
text by a .txt...
asked 4 hours ago