Answered You can hire a professional tutor to get the answer.

QUESTION

**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.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question