Question 1

In an exponential smoothing method, weights are assigned

Accepted Answer

A) just to the current actual and predicted values. 
B) just to the previous data point and its predicted value. 
C) to all past data points with weight $\alpha$. 
D) to all past data points with more recent data points receiving more weight. 
A) just to the current actual and predicted values. 
B) just to the previous data point and its predicted value. 
C) to all past data points with weight $\alpha$. 
D) to all past data points with more recent data points receiving more weight.

Question 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 F9 to compute the second average when using the double moving average method with k = 4?

Accepted Answer

A) =Average($E$3:$E$9) 
B) =Average($D$3:$D$9) 
C) =Average(D3:D9) 
D) =Average(D6:D9) 
A) =Average($E$3:$E$9) 
B) =Average($D$3:$D$9) 
C) =Average(D3:D9) 
D) =Average(D6:D9)

Question 3

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?

Accepted Answer

The answer of  
The following questions use the data...

Question 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. If predicting the cars sold for time period 14, what formula must be placed in cell B16?

Accepted Answer

A) =AVERAGE(B12:B15) 
B) =AVERAGE(B12:B15)/4 
C) =TREND(B12:B15) 
D) =B14 
A) =AVERAGE(B12:B15) 
B) =AVERAGE(B12:B15)/4 
C) =TREND(B12:B15) 
D) =B14

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

Accepted Answer

The answer of  
The following questions use the data...

Question 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. He wants to use regression and a linear trend model.
    
-Refer to Exhibit 11.22. Interpret the R2 value for your model.

Accepted Answer

The R² value of 0.791

Question 7

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 F7 to compute the Trend value for year 2 Quarter 1?

Accepted Answer

A) =$D$18*(E6-E7)+(1-$D$18)*F6 
B) =$D$18*(E7-E6)+$D$18*F6 
C) =$D$18*(E7-E6)+(1-$D$18)*F6 
D) =$D$18*(E7-E6)*(1-$D$18) 
A) =$D$18*(E6-E7)+(1-$D$18)*F6 
B) =$D$18*(E7-E6)+$D$18*F6 
C) =$D$18*(E7-E6)+(1-$D$18)*F6 
D) =$D$18*(E7-E6)*(1-$D$18)

Question 8

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?

Accepted Answer

A) 79.20 $\le$ forecast < 79.30 
B) 79.60 $\le$ forecast < 79.70 
C) 80.10 $\le$ forecast < 80.20 
D) 81.95 $\le$ forecast < 82.05 
A) 79.20 $\le$ forecast < 79.30 
B) 79.60 $\le$ forecast < 79.70 
C) 80.10 $\le$ forecast < 80.20 
D) 81.95 $\le$ forecast < 82.05

Question 9

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 H3 to compute the Seasonal Forecast value for year 1 Quarter 1?

Accepted Answer

A) =F3*VLOOKUP(B3,$B$18:$C$21,2) 
B) =F3*HLOOKUP(B3,$B$18:$B$21,2) 
C) =F3*VLOOKUP(B3,$B$18:$B$21,2) 
D) =F3*VLOOKUP(B3,$C$18:$C$21,2) 
A) =F3*VLOOKUP(B3,$B$18:$C$21,2) 
B) =F3*HLOOKUP(B3,$B$18:$B$21,2) 
C) =F3*VLOOKUP(B3,$B$18:$B$21,2) 
D) =F3*VLOOKUP(B3,$C$18:$C$21,2)

Question 10

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

Accepted Answer

A) t+1 = f(Xt, Y1, Z2, ...) 
B) t = f(Yt, Yt-1, Yt-2, ...) 
C) Yt+1 = f(Yt, Yt-1, Yt-2, ...) 
D)   
A) t+1 = f(Xt, Y1, Z2, ...) 
B) t = f(Yt, Yt-1, Yt-2, ...) 
C) Yt+1 = f(Yt, Yt-1, Yt-2, ...) 
D)

Question 11

What is the correct form of the exponential smoothing model?

Accepted Answer

A)   
B)   
C)   
D)   
A)   
B)   
C)   
D)

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

Accepted Answer

A) =TREND($H$3:$H$14,$C$3:$G$14, C3:G3) 
B) =TREND($H$3:$H$14,$B$3:$G$14, B3:G3) 
C) =TREND($H$3:$H$14,$A$3:$G$14, A3:G3) 
D) =TREND($H$3:$H$14,$C$3:$D$14, C3:D3) 
A) =TREND($H$3:$H$14,$C$3:$G$14, C3:G3) 
B) =TREND($H$3:$H$14,$B$3:$G$14, B3:G3) 
C) =TREND($H$3:$H$14,$A$3:$G$14, A3:G3) 
D) =TREND($H$3:$H$14,$C$3:$D$14, C3:D3)

Question 13

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. Which column in the spreadsheet represents the independent variable for a regression model?

Accepted Answer

A) A 
B) B 
C) C 
D) D 
A) A 
B) B 
C) C 
D) D

Question 14

Which of the following is the common approach to time-series analysis?

Accepted Answer

A) Try several techniques and use the best results. 
B) Plot the data and count the peaks to determine a value for k. 
C) Plot the data and use the TREND() function. 
D) Use a stationary model since it is the most robust. 
A) Try several techniques and use the best results. 
B) Plot the data and count the peaks to determine a value for k. 
C) Plot the data and use the TREND() function. 
D) Use a stationary model since it is the most robust.

Question 15

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

Accepted Answer

A) B3:B14 
B) C3:C14 
C) D3:D14 
D) E3:E14 
A) B3:B14 
B) C3:C14 
C) D3:D14 
D) E3:E14

Question 16

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?

Accepted Answer

The answer of  
The following questions use the data...

In an exponential smoothing method, weights are assigned

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?

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?

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. Interpret the R² value for your model.

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

What is the correct form of the exponential smoothing model?

Which of the following is the common approach to time-series analysis?

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming and Evolutionary Optimization

Regression Analysis

Discriminant Analysis

Introduction to Simulation Using Risk Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters

Exam 11: Time Series Forecasting

In an exponential smoothing method, weights are assigned

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?

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?

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. Interpret the R2 value for your model.

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

What is the correct form of the exponential smoothing model?

Which of the following is the common approach to time-series analysis?

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming and Evolutionary Optimization

Regression Analysis

Discriminant Analysis

Introduction to Simulation Using Risk Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters

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. Interpret the R² value for your model.