Exam 11: Time Series Forecasting

Exhibit 11.25 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use a seasonal regression model to forecast sales. -Refer to Exhibit 11.25. Based on the regression output what formulas should go in cells D3:I14?

Exhibit 11.16 The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs your help in analyzing this data using exponential smoothing. -Refer to Exhibit 11.16. What formulas should go in cells C3:C16 of the spreadsheet if Bill uses an exponential smoothing forecasting model?

Forecasting into distant future periods

Which of the following is true of 2-month moving average forecasting function extrapolation?

Exhibit 11.11 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using seasonal indices. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.11. What formula should be entered in cell C18 to compute the Seasonal Index value for quarter 1?

Exhibit 11.8 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using Winter's method. The store has collected 12 quarters of data and needs your help to analyze the data. -Refer to Exhibit 11.8. What formula should be entered in cell E7 to compute the base level value for year 2 Quarter 1?

What is the correct form of the exponential smoothing model?

Exhibit 11.10 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using a quadratic trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.10. How is a quadratic term added to the problem if we want to develop a quadratic trend model?

Exhibit 11.1 The following questions use the data below. Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages. -Refer to Exhibit 11.1. What is the 4-month moving average forecast for month 5?

Exhibit 11.6 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4. -Refer to Exhibit 11.6. What formula should be entered in cell F9 to compute the second average when using the double moving average method with k = 4?

Which of the following is not a quantitative technique for evaluating the accuracy of a time-series modeling technique?

The TREND( ) function can be used to calculate the estimated values for linear regression models.

Exhibit 11.17 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the additive seasonal method. -Refer to Exhibit 11.17. What is the forecast for time period 13?

In an exponential smoothing method, weights are assigned

Exhibit 11.18 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the multiplicative seasonal method. -Refer to Exhibit 11.18. What formulas should go in cells E3:G16 of the spreadsheet if the multiplicative seasonal method is used to forecast sales?

Exhibit 11.22 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use regression and a linear trend model. -Refer to Exhibit 11.22. What is the forecast for time period 13?

Exhibit 11.16 The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs your help in analyzing this data using exponential smoothing. -Refer to Exhibit 11.16. What is the forecast for time period 13?

Exhibit 11.9 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using a linear trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.9. What formula should be entered in cell E3 to compute the linear trend for year 1 Quarter 1?

As alpha increases the exponential smoothing model

Exhibit 11.13 The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs your help in analyzing this data using moving averages. -Refer to Exhibit 11.13. What is the forecast for time periods 13-15?