Stats Solutions

[All Steps] Consider the quarterly sales given in the table below. Quarterly Sales Year Net Sales (millions) 1996 $4,053 1996 5,075 1996 5,159 1996 6,050 1997

Question: Consider the quarterly sales given in the table below.

Quarterly Sales
Year Net Sales (millions)
1996 $4,053
1996 5,075
1996 5,159
1996 6,050
1997 4,213
1997 5,086
1997 5,362
1997 6,256
1998 4,353
1998 5,258
1998 5,544
1998 7,193
1999 5,114
1999 4,982
1999 4,591
1999 5,680
2000 4,191
2000 4,928
2000 4,909
2000 6,410
  1. Draw a time series plot for this data set and describe any trend and seasonal behavior that you see.
  2. Plot the moving average values on the same graph as the original data. (4 quarters)
  3. Find the seasonal index for each quarter. Which is generally the best quarter for sales?
  4. Plot the seasonally adjusted series with the original data.
  5. Find the regression equation to predict the long-term trend in seasonally adjusted sales for each time period. Does the trend equation show a significant trend over time.

Price: $2.99
Solution: The downloadable solution consists of 6 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