Answered You can hire a professional tutor to get the answer.
**Please show all work** ATTACH EXCEL SHEET OR IF POSSIBLE, USE STATA The quarterly sales of the TRK-50 mountain bike for the previous four years by
**QUESTION/DATA IS ATTACHED**
The quarterly sales of the TRK-50 mountain bike for the previous four years by a bicycle shop in Switzerland is presented in Table 6.8.
Use Stata/Excel to generate a scatter plot of sales versus time.
Next, use Stata/Excel to estimate the following model (see attachment)
- 1.From your scatter, what type of trend appears to exist?
- 2.From your scatter, what type of seasonal variation appears to exist?
- 3.Based on your regression results, are all of the independent variables important?
- 4.Write the prediction equation for the model and use it to calculate and (see attachment)
- and
- Test for positive autocorrelation using the DW statistic with a 5 percent level of significance.