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.763

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 with AI-Powered 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

Personal Financial Planning

Authors: Lawrence J. Gitman, Michael D. Joehnk, Randy Billingsley

13th edition

1111971633, 978-1111971632

Students also viewed these Mathematics questions