Exam 11: Time Series Forecasting

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 is the forecast for time period 13?

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

Exhibit 11.23 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 quadratic trend model to forecast sales. -Refer to Exhibit 11.23. What is the forecast for time period 13?

Exhibit 11.5 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 effects model. -Refer to Exhibit 11.5. What formula should be entered in cell E3 to compute the base level when using the multiplicative seasonal effects method?

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 are predicted sales for the fourth quarter of year 4?

Seasonality in a time series is indicated by

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 formula should be entered in cell C13 to compute the 4-month moving average forecast for month 11?

The determination of the MSE-minimizing value of the w_i is a non-linear optimization problem because

A time series is a set of observations on a quantitative variable collected over time.

The correct formula for a k period moving average is

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. What is the forecast for time period 13?

Exhibit 11.24 The following questions use the data below. A store wants to predict quarterly sales. The owners have has collected 3 years of sales data and wants your help in analyzing the data. They want to use a quadratic trend model with seasonality to forecast sales. -Refer to Exhibit 11.24. What is the forecast for time period 13?

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 G3 to compute the seasonal factor for year 1 Quarter 1?

Solver can be used to estimate model parameters when the time series is stationary and additive seasonal effects are present.

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. -Refer to Exhibit 11.4. What formula should be entered in cell G12 to compute the forecast for time period 10?

Exhibit 11.5 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 effects model. -Refer to Exhibit 11.5. What formula should be entered in cell E7 to compute the remaining expected levels?

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 13?

Exhibit 11.5 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 effects model. -Refer to Exhibit 11.5. What are predicted sales for time period 13 using the data in the spreadsheet?

A time series which has a significant upward or downward trend is referred to as

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. The store wishes to use Solver to find the optimal values for cell E3. Provide the following Analytic Solver Platform (ASP) settings. Objective Cell: ​ Variables Cells: ​ Constraints Cells: