Stats Solutions

[Solution Library] A consulting firm estimates the following quarterly sales forecasting model: Q_t=a+bt+cD The consulting firm estimates the equation using

Question: A consulting firm estimates the following quarterly sales forecasting model:

\[{{Q}_{t}}=a+bt+cD\]

The consulting firm estimates the equation using quarterly data from 2000, quarter 1, to 2010, quarter 3, for a total of 43 observations (t=1 ... 43). The variable D is a dummy variable for the second quarter, where D=1 for the second quarter and D=0 otherwise. The results of the estimation are as follows.

  1. At the 5 percent level of significance, is there a statistically significant trend in sales? Why?
  2. Given the results in the table, is the trend in sales increasing or decreasing? Why?
  3. At the 5 percent level of significance, are sales in the second quarter statistically different than sales in the other quarters? If yes, are sales higher or lower than other quarters?
  4. What is the predicted level of sales in 2011, quarter 1?
  5. What is the predicted level of sales in 2011, quarter 2?
  6. What is the predicted level of sales in 2011, quarter 3?
  7. What is the predicted level of sales in 2011, quarter 4?

Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in