Exam 11: Time Series Forecasting

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 F3 to compute the quadratic trend for year 1 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 Excel function will compute the mean squared error in cell C18 of the spreadsheet?

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?

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

The correct formula for the weighted moving average extrapolation technique with different weights is

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

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

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?

In the formula for MAD, MAPE, and MSE, the Y_t and _t terms represent

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?

Which of the following statements are true regarding the difference between forecasts using exponential smoothing and forecasts using a weighted moving average method?

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 F4 to compute the trend when using Holt's method?

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

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?

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

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

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?

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?

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 F7 to compute the seasonal factor using the additive seasonal effects model?

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 method. -Refer to Exhibit 11.19. What formulas should go in cells E6:G14 of the spreadsheet if the double moving average method is used to forecast sales?