Question 2: The quarterly sales of the TRK-50 mountain bike for the previous four years by a bicycle shop in Switzerland (attached).Use Stata to generate a scatter plot of sales versus time.Next, use Stata to estimate the following model

a.From your scatter, what type of trend appears to exist?

b.From your scatter, what type of seasonal variation appears to exist?

c.Based on your regression results, are all of the independent variables important?

d.Write the prediction equation for the model and use it to calculate and .

e.Test for positive autocorrelation using the DW statistic with a 5 percent level of significance.

YX

101

312

433

164

115

336

457

178

139

3410

4811

1912

1513

3714

5115

2116