The data in Toys R Us are quarterly revenues (in $millions) for Toys R Us from 1996-Q1
Question:
The data in Toys R Us are quarterly revenues (in $millions) for Toys R Us from 1996-Q1 through 2015-Q1. (Data extracted from Standard & Poor's Stock Reports, November 1995, November 1998, and April 2002, and Toys R Us, Inc., www.toysrus.com.)
a. Do you think that the revenues for Toys R Us are subject to seasonal variation? Explain.
b. Plot the data. Does this chart support your answer in (a)?
c. Develop an exponential trend forecasting equation with quarterly components.
d. Interpret the quarterly compound growth rate.
e. Interpret the quarterly multipliers.
f. What are the forecasts for 2015-Q2, 2015-Q3, 2015-Q4, and all four quarters of 2016?
Step by Step Answer:
Statistics For Managers Using Microsoft Excel
ISBN: 9780134173054
8th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat