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

Subject:StatisticsPrice: Bought3

Share With

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

 

I need to know the Updated forecast for the Amazon Sales accounting for Trend, Seasonality and Adjusted for the Serial Correlation using the AR(1) model?

This is all info I have for the problem