TABLE 16-12
A local store developed a multiplicative time-series model to forecast its revenues in
future quarters, using quarterly data on its revenues during the 5-year period from 2008
to 2012. The following is the resulting regression equation:
log10 = 6.102 + 0.012 X – 0.129 1 – 0.054 2 + 0.098 3
where is the estimated number of contracts in a quarter
X is the coded quarterly value with X = 0 in the first quarter of 2008
1 is a dummy variable equal to 1 in the first quarter of a year and 0 otherwise
2 is a dummy variable equal to 1 in the second quarter of a year and 0 otherwise
is a dummy variable equal to 1 in the third quarter of a year and 0 otherwise
Referring to Table 16-12, using the regression equation, what is the forecast for the
revenues in the third quarter of 2013?
TABLE 16-6
The president of a chain of department stores believes that her stores’ total sales have
been showing a linear trend since 1993. She uses Microsoft Excel to obtain the partial
output below. The dependent variable is sales (in millions of dollars), while the
independent variable is coded years, where 1993 is coded as 0, 1994 is coded as 1, etc.
SUMMARY OUTPUT
Referring to Table 16-6, the forecast for sales (in millions of dollars) in 2013 is
________.