Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Amazon Sales: We have Quarterly Amazon Sales (billion dollars) starting in Quarter 3 of 2013 through Quarter 2 of 2021. Assume in Quarter 2 of

Amazon Sales: We have Quarterly Amazon Sales (billion dollars) starting in Quarter 3 of 2013 through Quarter 2 of 2021. Assume in Quarter 2 of 2021 the Amazon Sales were 96.7 billion dollars. Use the output provided below to report the updated forecast for the Amazon Sales for Quarter 3 of 2021.

The variable time period is coded in the following way: Start with t = 1 for Quarter 3 of 2013, t = 2 for Quarter 4 of 2013. The value of t will increase by 1 for each subsequent quarter. In this example we have created indicator variables for Quarters 1, 2 and 3. Quarter 4 is the baselevel.

Using the output here for the model accounting for trend and seasonality as well as the output for the AR(1) model report the updated forecast for Amazon Sales in Quarter 3 of 2021.

A subset of the output posted below:

Response Revenues ($Billions) (Model accounting for a linear trend and seasonality)

Indicator Function Parameterization

Term

Estimate

Std Error

Prob>|t|

Intercept

22.67

2.170013

<.0001*

Time period

2.54

0.114

<.0001*

Quarter[ 1]

-10.44

2.377

0.0003*

Quarter[ 2]

-11.15

2.385

0.0001*

Quarter[ 3]

-8.77

2.291

0.0010*

Bivariate Fit of Residual Revenues ($Billions) 2 By Lag residuals (AR(1) Model output)

Parameter Estimates

Term

Estimate

Std Error

Prob>|t|

Intercept

-0.08

0.479

0.8598

Lag residuals

0.780

0.132

<.0001*

The Updated forecast for the Amazon Sales accounting for Trend, Seasonality and Adjusted for the Serial Correlation using the AR(1) model is: _________ billion dollars.

If the answer is 75.2432 billion dollars just type 75.243

Keep at least 3 decimal places for all parts of your calculation. Record your answer with at least 3 decimal places.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus With Applications

Authors: Margaret L Lial, Raymond N Greenwell, Nathan P Ritchey

10th Edition

0321831101, 9780321831101

More Books

Students also viewed these Mathematics questions

Question

6. What information processes operate in communication situations?

Answered: 1 week ago

Question

3. How can we use information and communication to generate trust?

Answered: 1 week ago