Exam 11: Time Series Forecasting

Exhibit 11.15 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 weighted moving averages. -Refer to Exhibit 11.15. What is the forecast for time period 13-15?

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 formulas should go in cells E3:G16 of the spreadsheet if the additive seasonal method is used to forecast sales?

Exhibit 11.3 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 exponential smoothing. -Refer to Exhibit 11.3. What formula should be entered in cell C4 to compute the exponential smoothing forecast for month 2?

Exhibit 11.4 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using the additive seasonal method. The store has collected 12 quarters of data and needs your help to analyze the data. -In the formula for MAD, MAPE, and MSE, the Y_t and terms represent

Exhibit 11.7 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using Holt's method. The store has collected 12 quarters of data and needs your help to analyze the data. -Refer to Exhibit 11.7. What are predicted sales for time period 2 using the data in the spreadsheet?

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 is the Input Y Range in the Regression command settings dialog box?

The general form of an extrapolation model for time-series analysis is

Exhibit 11.12 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using a seasonal regression model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is provided in the following table. -Refer to Exhibit 11.12. What Excel command can be used in cells F4:F14 in lieu of a formula based on the regression statistics?

How is mean absolute deviation calculated?

Exhibit 11.2 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 weighted moving averages. -Refer to Exhibit 11.2. What would be the forecasted value for time period 13?

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 I16 to compute the forecast for time period 14?

Which of the following describes a multiplicative seasonal effect in times series data?

A model or technique that uses past behavior of a time-series variable to predict the future is referred to as

Exhibit 11.21 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 Winter's method to forecast sales. -Refer to Exhibit 11.21. What formulas should go in cells E3:H16?

Exhibit 11.2 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 weighted moving averages. -Refer to Exhibit 11.2. Which cell in the spreadsheet is the objective cell in the Analytic Solver Platform (ASP) task pane area?

Exponential smoothing is applicable to non-stationary data.

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. What Excel command can be used in cells F4:F14 in lieu of a formula based on the regression statistics?

Exhibit 11.3 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 exponential smoothing. -Refer to Exhibit 11.3. What is the exponential smoothing forecast for month 2?

Exhibit 11.20 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 Holt's method. -Refer to Exhibit 11.20. What is the forecast for time period 13?

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 Excel function will compute the mean squared error in cell C18 of the spreadsheet?