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