Exam 11: Time Series Forecasting

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 E7 to compute the remaining expected levels?

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

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?

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?

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?

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 are predicted sales for time period 16 using the data in the spreadsheet?

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 H9 to compute the trend using the double moving average model with k = 4?

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?

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

Why might we not be able to build a regression model to predict a dependent variable?

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?

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?

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 formula should be entered in cell E4 to compute the base level when using Holt's method?

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?

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?

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 would be the forecasted values for time periods 13 and 14?

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 E3 to compute the base level when using the additive seasonal effects method?

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 formula should be entered in cell I3 to compute the Seasonal Value for year 1 Quarter 1?

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

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?