Spreadsheet Modeling And Decision Analysis 7th Edition By Cliff Ragsdale – Test Bank
1. Why might we not be able to build a regression model to predict a dependent variable?
a. We might not know the independent variables.
b. There might not be any data available for the independent variables.
c. The regression model might not fit the data well.
d. All of these are true.
2. A model or technique that uses past behavior of a time-series variable to predict the future is referred to as
a. a forecasting model.
b. an extrapolation model.
c. a trend model.
d. all of these.
3. A time series which has no significant upward or downward trend is referred to as
4. A time series which has a significant upward or downward trend is referred to as
5. Which of the following is the common approach to time-series analysis?
a. Try several techniques and use the best results.
b. Plot the data and count the peaks to determine a value for k .
c. Plot the data and use the TREND() function.
d. Use a stationary model since it is the most robust.
6. Which of the following is not a quantitative technique for evaluating the accuracy of a time-series modeling technique?
a. Constructing line graphs of the data.
b. The mean absolute deviation.
c. The mean absolute percent error.
d. The root mean square error.
7. A technique that analyzes past behavior of a time-series variable to predict the future is referred to as
a. a regression model.
b. a seasonal model.
c. a past performance model.
d. an extrapolation model.
8. How is mean absolute deviation calculated? a.
9. In the formula for MAD, MAPE, and MSE, the Yt and terms represent
a. the actual and mean values, respectively.
b. the actual and forecasted values, respectively.
c. the forecasted and actual values, respectively.
d. the predicted and forecasted values, respectively.
10. The general form of an extrapolation model for time-series analysis is a.