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. $\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & & \text { Number of } & \text { 2-Month Weighted } & & & \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Moving Avg. } & & \text { Weights } & \\ \hline 3 & 1 & 70 & & & \text { w1 } & 0.244 \\ \hline 4 & 2 & 80 & & & \text { w2 } & 0.756 \\ \hline 5 & 3 & 66 & & & \text { sum } & 1.000 \\ \hline 6 & 4 & 74 & 76.59 & & & \\ \hline 7 & 5 & 64 & 67.95 & & & \\ \hline 8 & 6 & 76 & 71.56 & & & \\ \hline 9 & 7 & 72 & 66.93 & & & \\ \hline 10 & 8 & 82 & 75.02 & & & \\ \hline 11 & 9 & 82 & 74.44 & & & \\ \hline 12 & 10 & 76 & 82.00 & & & \\ \hline 13 & 11 & 84 & 80.54 & & & \\ \hline 14 & 12 & 80 & 77.95 & & & \\ \hline 15 & & & & & & \\ \hline 16 & & \text { MSE } & 26.72 & & & \\ \hline \end{array}$ -Refer to Exhibit 11.2.What would be the forecasted value for time period 13?

A) 83.024. B) 80.796. C) 79.245. D) 79.908. A) 83.024. B) 80.796. C) 79.245. D) 79.908.

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. \[\begin{array} { | r | c | c | c | } \hline & \text { A } & \text { B } & \text { C } \\ \hline 1 & & \text { Number of } & \text { 4-Month } \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Moving Ave } \\ \hline 3 & 1 & 70 & \\ \hline 4 & 2 & 80 & \\ \hline 5 & 3 & 66 & \\ \hline 6 & 4 & 74 & \\ \hline 7 & 5 & 64 & \\ \hline 8 & 6 & 76 & 71.00 \\ \hline 9 & 7 & 72 & 70.00 \\ \hline 10 & 8 & 82 & 71.50 \\ \hline 11 & 9 & 82 & 73.50 \\ \hline 12 & 10 & 76 & 7.00 \\ \hline 13 & 11 & 84 & 78.00 \\ \hline 14 & 12 & 80 & 81.00 \\ \hline 15 & 13 & & \\ \hline 16 & 14 & & \\ \hline 17 & & & \\ \hline 18 & & \text { MSE } & 40.59 \\ \hline \end{array}\] -Refer to Exhibit 11.1.What would be the forecasted values for time periods 13 and 14?

A) 81.00 and 79.50. B) 78.00 and 78.00. C) 80.50 and 80.13. D) 80.50 and 80.00. A) 81.00 and 79.50. B) 78.00 and 78.00. C) 80.50 and 80.13. D) 80.50 and 80.00.

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. \[\begin{array} { | r | c | c | c | } \hline & \text { A } & \text { B } & \text { C } \\ \hline 1 & & \text { Number of } & \text { 4-Month } \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Moving Ave } \\ \hline 3 & 1 & 70 & \\ \hline 4 & 2 & 80 & \\ \hline 5 & 3 & 66 & \\ \hline 6 & 4 & 74 & \\ \hline 7 & 5 & 64 & \\ \hline 8 & 6 & 76 & 71.00 \\ \hline 9 & 7 & 72 & 70.00 \\ \hline 10 & 8 & 82 & 71.50 \\ \hline 11 & 9 & 82 & 73.50 \\ \hline 12 & 10 & 76 & 7.00 \\ \hline 13 & 11 & 84 & 78.00 \\ \hline 14 & 12 & 80 & 81.00 \\ \hline 15 & 13 & & \\ \hline 16 & 14 & & \\ \hline 17 & & & \\ \hline 18 & & \text { MSE } & 40.59 \\ \hline \end{array}\] -Refer to Exhibit 11.1.What Excel function will compute the mean squared error in cell C18 of the spreadsheet?

A) =SUMXMY2B7:B14,C7:C14) B) =SUMXMY2B3:B14,C3:C14)/COUNTC3:C14) C) =SUMXMY2B7:B14,C7:C14)/COUNTC7:C14) D) =SUMPRODUCTB7:B14,C7:C14)/COUNTC7:C14) A) =SUMXMY2B7:B14,C7:C14) B) =SUMXMY2B3:B14,C3:C14)/COUNTC3:C14) C) =SUMXMY2B7:B14,C7:C14)/COUNTC7:C14) D) =SUMPRODUCTB7:B14,C7:C14)/COUNTC7:C14)

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. $\begin{array}{|c|r|} \hline \begin{array}{l} \text { Regression } \\ \text { Statistics } \end{array} & \\ \hline & \text { Coefficients } \\ \hline \text { Intercept } & 263.4545 \\ \hline \text { X Variable 1 } & 5.985514 \\ \hline \text { X Variable 2 } & 4.922577 \\ \hline \end{array}$ $\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & & & \text { Time } & & \text { Actual } & \text { Quadratic } \\ \hline 2 & \text { Year } & \text { Qtr } & \text { Period } & \text { Time }^{\wedge} 2& \text { Sales } & \text { Trend } \\ \hline 3 & 1 & 1 & 1 & 1 & 284 & \\ \hline 4 & & 2 & 2 & 4 & 184 & 295.1 \\ \hline 5 & & 3 & 3 & 9 & 365 & 325.7 \\ \hline 6 & & 4 & 4 & 16 & 492 & 366.2 \\ \hline 7 & 2 & 1 & 5 & 25 & 485 & 416.4 \\ \hline 8 & & 2 & 6 & 36 & 277 & 476.6 \\ \hline 9 & & 3 & 7 & 49 & 606 & 546.6 \\ \hline 10 & & 4 & 8 & 64 & 722 & 626.4 \\ \hline 11 & 3 & 1 & 9 & 81 & 763 & 716.1 \\ \hline 12 & & 2 & 10 & 100 & 593 & 815.6 \\ \hline 13 & & 3 & 11 & 121 & 912 & 924.9 \\ \hline 14 & & 4 & 12 & 144 & 1145 & 1044.1 \\ \hline \end{array}$ -Refer to Exhibit 11.10.What is the Input X Range in the Regression command settings dialog box?

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

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. \(\begin{array}{|c|c|c|c|c|r|r|r|l|l|l|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } & \text { G } & \text { H } & \text { I } & \text { J } \\ \hline 1 & & & \text { Time } & \text { Actual } & \text { Base } & \text { Seasonal } & \text { Predicted } & & & \\ \hline 2 & \text { Year } & \text { Qtr } & \text { Period } & \begin{array}{c} \text { Sale } \\ \text { s } \end{array} & \text { Level } & \text { Factor } & \text { Sales } & & & \\ \hline 3 & 1 & 1 & 1 & 284 & 331.25 & -47.250 & & & \text { alpha } & 0.764 \\ \hline 4 & & 2 & 2 & 184 & 331.25 & -147.250 & & & \text { beta } & 1.0 \\ \hline 5 & & 3 & 3 & 365 & 331.25 & 33.750 & & & & \\ \hline 6 & & 4 & 4 & 492 & 331.25 & 160.750 & & & & \\ \hline 7 & 2 & 1 & 5 & 485 & 484.85 & 0.146 & 284.00 & & & \\ \hline 8 & & 2 & 6 & 277 & 438.54 & -161.541 & 337.60 & & & \\ \hline 10 & & 4 & 8 & 722 & 556.41 & 165.591 & 701.47 & & & \\ \hline 11 & 3 & 1 & 9 & 763 & 714.17 & 48.827 & 556.56 & & & \\ \hline 12 & & 2 & 10 & 593 & 745.02 & -152.022 & 552.63 & & & \\ \hline 13 & & 3 & 11 & 912 & 822.74 & 89.260 & 810.30 & & & \\ \hline 14 & & 4 & 12 & 1145 & 942.47 & 202.534 & 988.33 & & & \\ \hline 15 & & & & & & & & & & \\ \hline 16 & & & & & & &17688.77 & & & \\ \hline \end{array}\) -Refer to Exhibit 11.4.What formula should be entered in cell F7 to compute the seasonal factor using the additive seasonal effects model?

A) =$J$3*D4+1-$J$3)*E3+F3) B) =$J$4*D7-E7)+1-$J$4)*F3 C) =$J$4*E7-E6)+1-$J$4)*E6 D) =$J$3*G3+1-$J$3)*D3+G3) A) =$J$3*D4+1-$J$3)*E3+F3) B) =$J$4*D7-E7)+1-$J$4)*F3 C) =$J$4*E7-E6)+1-$J$4)*E6 D) =$J$3*G3+1-$J$3)*D3+G3)

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. \[\begin{array} { | r | c | c | c | } \hline & \text { A } & \text { B } & \text { C } \\ \hline 1 & & \text { Number of } & \text { 4-Month } \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Moving Ave } \\ \hline 3 & 1 & 70 & \\ \hline 4 & 2 & 80 & \\ \hline 5 & 3 & 66 & \\ \hline 6 & 4 & 74 & \\ \hline 7 & 5 & 64 & \\ \hline 8 & 6 & 76 & 71.00 \\ \hline 9 & 7 & 72 & 70.00 \\ \hline 10 & 8 & 82 & 71.50 \\ \hline 11 & 9 & 82 & 73.50 \\ \hline 12 & 10 & 76 & 7.00 \\ \hline 13 & 11 & 84 & 78.00 \\ \hline 14 & 12 & 80 & 81.00 \\ \hline 15 & 13 & & \\ \hline 16 & 14 & & \\ \hline 17 & & & \\ \hline 18 & & \text { MSE } & 40.59 \\ \hline \end{array}\] -Refer to Exhibit 11.1.What is the 4-month moving average forecast for month 5?

A) 71 B) 72.5 C) 74 D) 75 A) 71 B) 72.5 C) 74 D) 75

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. $\begin{array}{|c|r|} \hline \begin{array}{l} \text { Regression } \\ \text { Statistics } \end{array} & \\ \hline & \text { Coefficients } \\ \hline \text { Intercept } & 263.4545 \\ \hline \text { X Variable 1 } & 5.985514 \\ \hline \text { X Variable 2 } & 4.922577 \\ \hline \end{array}$ $\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } \\ \hline 1 & & & \text { Time } & & \text { Actual } & \text { Quadratic } \\ \hline 2 & \text { Year } & \text { Qtr } & \text { Period } & \text { Time }^{\wedge} 2& \text { Sales } & \text { Trend } \\ \hline 3 & 1 & 1 & 1 & 1 & 284 & \\ \hline 4 & & 2 & 2 & 4 & 184 & 295.1 \\ \hline 5 & & 3 & 3 & 9 & 365 & 325.7 \\ \hline 6 & & 4 & 4 & 16 & 492 & 366.2 \\ \hline 7 & 2 & 1 & 5 & 25 & 485 & 416.4 \\ \hline 8 & & 2 & 6 & 36 & 277 & 476.6 \\ \hline 9 & & 3 & 7 & 49 & 606 & 546.6 \\ \hline 10 & & 4 & 8 & 64 & 722 & 626.4 \\ \hline 11 & 3 & 1 & 9 & 81 & 763 & 716.1 \\ \hline 12 & & 2 & 10 & 100 & 593 & 815.6 \\ \hline 13 & & 3 & 11 & 121 & 912 & 924.9 \\ \hline 14 & & 4 & 12 & 144 & 1145 & 1044.1 \\ \hline \end{array}$ -Refer to Exhibit 11.10.What formula should be entered in cell F3 to compute the quadratic trend for year 1 Quarter 1?

A) = 263.4545 * C3 + 5.985514 * D3 + 4.922577 B) = 263.4545 + 5.985514 * D3 + 4.922577 * C3 C) = 263.4545 + 5.985514 * C2 + 4.922577 * D2 D) = 263.4545 + 5.985514 * C3 + 4.922577 * D3 A) = 263.4545 * C3 + 5.985514 * D3 + 4.922577 B) = 263.4545 + 5.985514 * D3 + 4.922577 * C3 C) = 263.4545 + 5.985514 * C2 + 4.922577 * D2 D) = 263.4545 + 5.985514 * C3 + 4.922577 * D3

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. \[\begin{array} { | l | l | } \hline \text { Regrassion } & \\ \text { Satisties } & \\ \hline & \text { Coefficients } \\ \hline \text { Intercept } & 114.136 \\ \hline X \text { Variable } & 69.979 \\ \hline \end{array}\] $\begin{array}{|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\ \hline 1 & & & \text { Time } & \text { Actual } & \text { Linear } \\ \hline 2 & \text { Year } & \text { Qtr } & \text { Period } & \text { Sales } & \text { Trend } \\ \hline 3 & 1 & 1 & 1 & 284 & \\ \hline 4 & & 2 & 2 & 184 & 254.1 \\ \hline 5 & & 3 & 3 & 365 & 324.1 \\ \hline 6 & & 4 & 4 & 492 & 394.1 \\ \hline 7 & 2 & 1 & 5 & 485 & 464.0 \\ \hline 8 & & 2 & 6 & 277 & 534.0 \\ \hline 9 & & 3 & 7 & 606 & 604.0 \\ \hline 10 & & 4 & 8 & 722 & 674.0 \\ \hline 11 & 3 & 1 & 9 & 763 & 743.9 \\ \hline 12 & & 2 & 10 & 593 & 813.9 \\ \hline 13 & & 3 & 11 & 912 & 883.9 \\ \hline 14 & & 4 & 12 & 1145 & 953.9 \\ \hline \end{array}$ -Refer to Exhibit 11.9.What formula should be entered in cell E3 to compute the linear trend for year 1 Quarter 1?

A) = 114.1364 + 69.7902 * 3 B) = 114.1364 + 69.7902 * 1 C) = 114.1364 + 69.7902 * 1991 D) = 114.1364 + 69.7902 * 284 A) = 114.1364 + 69.7902 * 3 B) = 114.1364 + 69.7902 * 1 C) = 114.1364 + 69.7902 * 1991 D) = 114.1364 + 69.7902 * 284

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. \[\begin{array} { | l | l | } \hline \text { Regrassion } & \\ \text { Satisties } & \\ \hline & \text { Coefficients } \\ \hline \text { Intercept } & 114.136 \\ \hline X \text { Variable } & 69.979 \\ \hline \end{array}\] $\begin{array}{|c|c|c|c|c|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\ \hline 1 & & & \text { Time } & \text { Actual } & \text { Linear } \\ \hline 2 & \text { Year } & \text { Qtr } & \text { Period } & \text { Sales } & \text { Trend } \\ \hline 3 & 1 & 1 & 1 & 284 & \\ \hline 4 & & 2 & 2 & 184 & 254.1 \\ \hline 5 & & 3 & 3 & 365 & 324.1 \\ \hline 6 & & 4 & 4 & 492 & 394.1 \\ \hline 7 & 2 & 1 & 5 & 485 & 464.0 \\ \hline 8 & & 2 & 6 & 277 & 534.0 \\ \hline 9 & & 3 & 7 & 606 & 604.0 \\ \hline 10 & & 4 & 8 & 722 & 674.0 \\ \hline 11 & 3 & 1 & 9 & 763 & 743.9 \\ \hline 12 & & 2 & 10 & 593 & 813.9 \\ \hline 13 & & 3 & 11 & 912 & 883.9 \\ \hline 14 & & 4 & 12 & 1145 & 953.9 \\ \hline \end{array}$ -Refer to Exhibit 11.9.Which column in the spreadsheet represents the independent variable for a regression model?

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

Exam 11: Time Series Forecasting

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. A B C D E F 1 Number of 2-Month Weighted 2 Time Period Cars Sold Moving Avg. Weights 3 1 70 w1 0.244 4 2 80 w2 0.756 5 3 66 sum 1.000 6 4 74 76.59 7 5 64 67.95 8 6 76 71.56 9 7 72 66.93 10 8 82 75.02 11 9 82 74.44 12 10 76 82.00 13 11 84 80.54 14 12 80 77.95 15 16 MSE 26.72 -Refer to Exhibit 11.2.What would be the forecasted value for time period 13?

(Multiple Choice)

4.8/5

(37)

Question 21

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. A B C 1 Number of 4-Month 2 Time Period Cars Sold Moving Ave 3 1 70 4 2 80 5 3 66 6 4 74 7 5 64 8 6 76 71.00 9 7 72 70.00 10 8 82 71.50 11 9 82 73.50 12 10 76 7.00 13 11 84 78.00 14 12 80 81.00 15 13 16 14 17 18 MSE 40.59 -Refer to Exhibit 11.1.What would be the forecasted values for time periods 13 and 14?

(Multiple Choice)

4.9/5

(24)

Question 22

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. Regression Statistics Coefficients Intercept 388.88 X Variable 1 10.052 X Variable 2 4.248 X Variable 3 -79.917 X Variable 4 -296.008 X Variable 5 -84.924 $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. \begin{array}{|c|c|} \hline \begin{array}{l} \text { Regression } \\ \text { Statistics } \end{array} & \\ \hline & \text { Coefficients } \\ \hline \text { Intercept } & 388.88 \\ \hline \begin{array}{c} \text { X Variable } \\ 1 \end{array} & 10.052 \\ \hline \begin{array}{c} \text { X Variable } \\ 2 \end{array} & 4.248 \\ \hline \begin{array}{c} \text { X Variable } \\ 3 \end{array} & -79.917 \\ \hline \begin{array}{c} \text { X Variable } \\ 4 \end{array} & -296.008 \\ \hline \begin{array}{c} \text { X Variable } \\ 5 \end{array} & -84.924 \\ \hline \end{array} -Refer to Exhibit 11.12.What formula should be entered in cell E3 to compute the value for the indicator variable for year 1 Quarter 1?$ -Refer to Exhibit 11.12.What formula should be entered in cell E3 to compute the value for the indicator variable for year 1 Quarter 1?

(Multiple Choice)

4.7/5

(40)

Question 23

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

(Multiple Choice)

4.8/5

(39)

Question 24

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. A B C 1 Number of 4-Month 2 Time Period Cars Sold Moving Ave 3 1 70 4 2 80 5 3 66 6 4 74 7 5 64 8 6 76 71.00 9 7 72 70.00 10 8 82 71.50 11 9 82 73.50 12 10 76 7.00 13 11 84 78.00 14 12 80 81.00 15 13 16 14 17 18 MSE 40.59 -Refer to Exhibit 11.1.What Excel function will compute the mean squared error in cell C18 of the spreadsheet?

(Multiple Choice)

4.8/5

(35)

Question 25

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

(Multiple Choice)

4.9/5

(38)

Question 26

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. Regression Statistics Coefficients Intercept 263.4545 X Variable 1 5.985514 X Variable 2 4.922577 A B C D E F 1 Time Actual Quadratic 2 Year Qtr Period 2 Sales Trend 3 1 1 1 1 284 4 2 2 4 184 295.1 5 3 3 9 365 325.7 6 4 4 16 492 366.2 7 2 1 5 25 485 416.4 8 2 6 36 277 476.6 9 3 7 49 606 546.6 10 4 8 64 722 626.4 11 3 1 9 81 763 716.1 12 2 10 100 593 815.6 13 3 11 121 912 924.9 14 4 12 144 1145 1044.1 -Refer to Exhibit 11.10.What is the Input X Range in the Regression command settings dialog box?

(Multiple Choice)

4.9/5

(38)

Question 27

In an exponential smoothing method,weights are assigned

(Multiple Choice)

4.9/5

(41)

Question 28

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 13 using the data in the spreadsheet?

(Multiple Choice)

4.9/5

(39)

Question 29

Which of the following is not a quantitative technique for evaluating the accuracy of a time-series modeling technique?

(Multiple Choice)

4.9/5

(38)

Question 30

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. A B C D E F G H I J 1 Time Actual Base Seasonal Predicted 2 Year Qtr Period Sale s Level Factor Sales 3 1 1 1 284 331.25 -47.250 alpha 0.764 4 2 2 184 331.25 -147.250 beta 1.0 5 3 3 365 331.25 33.750 6 4 4 492 331.25 160.750 7 2 1 5 485 484.85 0.146 284.00 8 2 6 277 438.54 -161.541 337.60 10 4 8 722 556.41 165.591 701.47 11 3 1 9 763 714.17 48.827 556.56 12 2 10 593 745.02 -152.022 552.63 13 3 11 912 822.74 89.260 810.30 14 4 12 1145 942.47 202.534 988.33 15 16 17688.77 -Refer to Exhibit 11.4.What formula should be entered in cell F7 to compute the seasonal factor using the additive seasonal effects model?

(Multiple Choice)

4.8/5

(45)

Question 31

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

(Multiple Choice)

4.9/5

(40)

Question 32

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 E7 to compute the base level value for year 2 Quarter 1?

(Multiple Choice)

4.9/5

(40)

Question 33

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. A B C 1 Number of 4-Month 2 Time Period Cars Sold Moving Ave 3 1 70 4 2 80 5 3 66 6 4 74 7 5 64 8 6 76 71.00 9 7 72 70.00 10 8 82 71.50 11 9 82 73.50 12 10 76 7.00 13 11 84 78.00 14 12 80 81.00 15 13 16 14 17 18 MSE 40.59 -Refer to Exhibit 11.1.What is the 4-month moving average forecast for month 5?

(Multiple Choice)

4.9/5

(41)

Question 34

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. Regression Statistics Coefficients Intercept 263.4545 X Variable 1 5.985514 X Variable 2 4.922577 A B C D E F 1 Time Actual Quadratic 2 Year Qtr Period 2 Sales Trend 3 1 1 1 1 284 4 2 2 4 184 295.1 5 3 3 9 365 325.7 6 4 4 16 492 366.2 7 2 1 5 25 485 416.4 8 2 6 36 277 476.6 9 3 7 49 606 546.6 10 4 8 64 722 626.4 11 3 1 9 81 763 716.1 12 2 10 100 593 815.6 13 3 11 121 912 924.9 14 4 12 144 1145 1044.1 -Refer to Exhibit 11.10.What formula should be entered in cell F3 to compute the quadratic trend for year 1 Quarter 1?

(Multiple Choice)

4.8/5

(40)

Question 35

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

(Multiple Choice)

4.8/5

(42)

Question 36

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. Regrassion Satisties Coefficients Intercept 114.136 X Variable 69.979 A B C D E 1 Time Actual Linear 2 Year Qtr Period Sales Trend 3 1 1 1 284 4 2 2 184 254.1 5 3 3 365 324.1 6 4 4 492 394.1 7 2 1 5 485 464.0 8 2 6 277 534.0 9 3 7 606 604.0 10 4 8 722 674.0 11 3 1 9 763 743.9 12 2 10 593 813.9 13 3 11 912 883.9 14 4 12 1145 953.9 -Refer to Exhibit 11.9.What formula should be entered in cell E3 to compute the linear trend for year 1 Quarter 1?

(Multiple Choice)

4.9/5

(36)

Question 37

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. Regrassion Satisties Coefficients Intercept 114.136 X Variable 69.979 A B C D E 1 Time Actual Linear 2 Year Qtr Period Sales Trend 3 1 1 1 284 4 2 2 184 254.1 5 3 3 365 324.1 6 4 4 492 394.1 7 2 1 5 485 464.0 8 2 6 277 534.0 9 3 7 606 604.0 10 4 8 722 674.0 11 3 1 9 763 743.9 12 2 10 593 813.9 13 3 11 912 883.9 14 4 12 1145 953.9 -Refer to Exhibit 11.9.Which column in the spreadsheet represents the independent variable for a regression model?

(Multiple Choice)

4.8/5

(30)

Question 38

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 H7 to compute the Predicted Sales value for year 2 Quarter 1?

(Multiple Choice)

4.8/5

(45)

Question 39

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

(Multiple Choice)

4.9/5

(38)

Question 40

In an exponential smoothing method,weights are assigned

Which of the following is not a quantitative technique for evaluating the accuracy of a time-series modeling technique?

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

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

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

Data Mining

Introduction to Simulation Using Analytic Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters