Using the data for the number of automobiles assembled in the United States for Problem 16.17 and
Question:
Using the data for the number of automobiles assembled in the United States for Problem 16.17 and Problem 16.29 (stored in Auto Production),
a. Perform a residual analysis for each model.
b. Compute the standard error of the estimate (S rx) for each model.
c. Compute the MAD for each model.
d. On the basis of (a) through (c) and the principle of parsimony, which forecasting model would you select? Discuss.
Problem 16.17
The file Auto Production contains the number of automobiles assembled in the United States (in thousands) from 1999 to 2018.
a. Plot the data.
b. Compute a linear trend forecasting equation and plot the trend line.
c. Compute a quadratic trend forecasting equation and plot the results.
d. Compute an exponential trend forecasting equation and plot the results.
e. Which model is the most appropriate?
f. Using the most appropriate model, forecast the U.S. automobiles assembled for 2019.
Problem 16.29
Using the data for Problem 16.17 concerning the number of automobiles assembled in the United States from 1999 to 2018 (stored in Auto Production),
a. Fit a third-order autoregressive model to the number of automobiles assembled in the United States and test for the significance of the third-order autoregressive parameter. (Use a = 0.05.)
b. If necessary, fit a second-order autoregressive model to the number of automobiles assembled in the United States and test for the significance of the second-order autoregressive parameter. (Use a = 0.05.)
c. If necessary, fit a first-order autoregressive model to the number of automobiles assembled in the United States and test for the significance of the first-order autoregressive parameter. (Use a = 0.05.)
d. Forecast the number of automobiles assembled in the United States for 2019.
Step by Step Answer:
Statistics For Managers Using Microsoft Excel
ISBN: 9780135969854
9th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat