Question 2. The quarterly sales of the TRK-50 mountain bike for the previous four years by a
Fantastic news! We've Found the answer you've been seeking!
Question:
Question 2. The quarterly sales of the TRK-50 mountain bike for the previous four years by a bicycle shop in Switzerland are presented in the table:
| Year | Quarter | Q = Sales |
|---|---|---|
| 2010 | 1 | 10 |
| 2 | 31 | |
| 3 | 43 | |
| 4 | 16 | |
| 2011 | 1 | 11 |
| 2 | 33 | |
| 3 | 45 | |
| 4 | 17 | |
| 2012 | 1 | 13 |
| 2 | 34 | |
| 3 | 48 | |
| 4 | 19 | |
| 2013 | 1 | 15 |
| 2 | 37 | |
| 3 | 51 | |
| 4 | 21 |
- Use the data to estimate the monthly trend in sales using a linear trend model of the form: Qt = a + bt. Does your statistical analysis indicate a trend? If so, is it an upward or downward trend and how great is it? Is it a statistically significant trend at 5 percent level of significance? PLEASE SHOW HOW IT WAS INPUT INTO EXCEL.
Expert Answer:
Posted Date:
