Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started