Utilizing the following table answer the following question:

 

Please use stata if possible and show all graphs please.

Utilizing the following table answer the following question:

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?

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

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

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

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

Please post in parts and thank you. I need this information ASAP.