Question: The next table presents the quarterly sales index for one brand of graphing calculator at a campus bookstore. The quarters are based on an academic

The next table presents the quarterly sales index for one brand of graphing calculator at a campus bookstore. The quarters are based on an academic year, so the first quarter represents fall; the second, winter; the third, spring; and the fourth, summer.

Define the time variable as t = 1 for the first quarter of 2011, t = 2 for the second quarter of 2011, etc. Consider the following seasonal dummy variables:

if Quarter 1 lo otherwise S1 if Quarter 2 Qi Q2= otherwise Si if Quarter 3 Q3 lo otherwise 이U 이니 이니.
Second Quarter First Fourth Quarter Third Quarter Year Quarter 2011 2012 2013 2014 2015 438 464 523 593 636 398 429 496

a. Write a regression model for E(Yt) as a function of t, Q1, Q2, and Q3.
b. Find and interpret the least squares estimates and evaluate the usefulness of the model.
c. Which of the assumptions about the random error component is in doubt when a regression model is fit to time series data?
d. Find the forecasts and the 95% prediction intervals for the 2016 quarterly sales. Interpret the result.

if Quarter 1 lo otherwise S1 if Quarter 2 Qi Q2= otherwise Si if Quarter 3 Q3 lo otherwise U . Second Quarter First Fourth Quarter Third Quarter Year Quarter 2011 2012 2013 2014 2015 438 464 523 593 636 398 429 496 576 640 252 376 425 456 160 216 318 398 498 526

Step by Step Solution

3.48 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a The regression model is b Using MINITAB the output is Regression Analysis Sales versus t Q1 Q2 Q3 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

1346-M-S-S-D(5458).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!