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

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

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. $\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \mathrm{B} & \text { C } & \text { D } & E & \mathrm{~F} \\ \hline 1 & & \text { Number of } & \text { Exp Smoothing } & & & \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Prediction } & & & \\ \hline 3 & 1 & 70 & 70.00 & & \text { alpha } & 0.346 \\ \hline 4 & 2 & 80 & 70.00 & & & \\ \hline 5 & 3 & 66 & 73.46 & & & \\ \hline 6 & 4 & 74 & 70.88 & & & \\ \hline 7 & 5 & 64 & 71.96 & & & \\ \hline 8 & 6 & 76 & 69.20 & & & \\ \hline 9 & 7 & 72 & 71.56 & & & \\ \hline 10 & 8 & 82 & 71.71 & & & \\ \hline 11 & 9 & 82 & 75.27 & & & \\ \hline 12 & 10 & 76 & 77.60 & & & \\ \hline 13 & 11 & 84 & 77.05 & & & \\ \hline 14 & 12 & 80 & 79.45 & & & \\ \hline 15 & & & & & & \\ \hline 16 & & \text { MSE } & 39.79 & & & \\ \hline \end{array}$ -Refer to Exhibit 11.3.What is the exponential smoothing forecast for month 2?

A) 69.75 ? forecast < 70.25 B) 73.00 ? forecast < 73.50 C) 74.75 ? forecast < 75.25 D) 79.75 ? forecast < 81.25 A) 69.75 ? forecast < 70.25 B) 73.00 ? forecast < 73.50 C) 74.75 ? forecast < 75.25 D) 79.75 ? forecast < 81.25

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. $\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \mathrm{B} & \text { C } & \text { D } & E & \mathrm{~F} \\ \hline 1 & & \text { Number of } & \text { Exp Smoothing } & & & \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Prediction } & & & \\ \hline 3 & 1 & 70 & 70.00 & & \text { alpha } & 0.346 \\ \hline 4 & 2 & 80 & 70.00 & & & \\ \hline 5 & 3 & 66 & 73.46 & & & \\ \hline 6 & 4 & 74 & 70.88 & & & \\ \hline 7 & 5 & 64 & 71.96 & & & \\ \hline 8 & 6 & 76 & 69.20 & & & \\ \hline 9 & 7 & 72 & 71.56 & & & \\ \hline 10 & 8 & 82 & 71.71 & & & \\ \hline 11 & 9 & 82 & 75.27 & & & \\ \hline 12 & 10 & 76 & 77.60 & & & \\ \hline 13 & 11 & 84 & 77.05 & & & \\ \hline 14 & 12 & 80 & 79.45 & & & \\ \hline 15 & & & & & & \\ \hline 16 & & \text { MSE } & 39.79 & & & \\ \hline \end{array}$ -Refer to Exhibit 11.3.Assume the forecasted value for month 13 is 79.64.What is the forecasted value for month 16?

A) 85.54. B) 83.64. C) 79.64. D) 82.00. A) 85.54. B) 83.64. C) 79.64. D) 82.00.

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. $\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \mathrm{B} & \text { C } & \text { D } & E & \mathrm{~F} \\ \hline 1 & & \text { Number of } & \text { Exp Smoothing } & & & \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Prediction } & & & \\ \hline 3 & 1 & 70 & 70.00 & & \text { alpha } & 0.346 \\ \hline 4 & 2 & 80 & 70.00 & & & \\ \hline 5 & 3 & 66 & 73.46 & & & \\ \hline 6 & 4 & 74 & 70.88 & & & \\ \hline 7 & 5 & 64 & 71.96 & & & \\ \hline 8 & 6 & 76 & 69.20 & & & \\ \hline 9 & 7 & 72 & 71.56 & & & \\ \hline 10 & 8 & 82 & 71.71 & & & \\ \hline 11 & 9 & 82 & 75.27 & & & \\ \hline 12 & 10 & 76 & 77.60 & & & \\ \hline 13 & 11 & 84 & 77.05 & & & \\ \hline 14 & 12 & 80 & 79.45 & & & \\ \hline 15 & & & & & & \\ \hline 16 & & \text { MSE } & 39.79 & & & \\ \hline \end{array}$ -Refer to Exhibit 11.3.What formula should be entered in cell C4 to compute the exponential smoothing forecast for month 2?

A) =C3-$F$3*B3-C3) B) =C3+$F$3*C3-B3) C) =B3+$F$3*B3-C3) D) =C3+$F$3*B3-C3) A) =C3-$F$3*B3-C3) B) =C3+$F$3*C3-B3) C) =B3+$F$3*B3-C3) D) =C3+$F$3*B3-C3)

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. $\begin{array}{|c|c|c|c|c|c|c|} \hline & \text { A } & \mathrm{B} & \text { C } & \text { D } & E & \mathrm{~F} \\ \hline 1 & & \text { Number of } & \text { Exp Smoothing } & & & \\ \hline 2 & \text { Time Period } & \text { Cars Sold } & \text { Prediction } & & & \\ \hline 3 & 1 & 70 & 70.00 & & \text { alpha } & 0.346 \\ \hline 4 & 2 & 80 & 70.00 & & & \\ \hline 5 & 3 & 66 & 73.46 & & & \\ \hline 6 & 4 & 74 & 70.88 & & & \\ \hline 7 & 5 & 64 & 71.96 & & & \\ \hline 8 & 6 & 76 & 69.20 & & & \\ \hline 9 & 7 & 72 & 71.56 & & & \\ \hline 10 & 8 & 82 & 71.71 & & & \\ \hline 11 & 9 & 82 & 75.27 & & & \\ \hline 12 & 10 & 76 & 77.60 & & & \\ \hline 13 & 11 & 84 & 77.05 & & & \\ \hline 14 & 12 & 80 & 79.45 & & & \\ \hline 15 & & & & & & \\ \hline 16 & & \text { MSE } & 39.79 & & & \\ \hline \end{array}$ -Refer to Exhibit 11.3.What is the exponential smoothing forecast for month 13?

A) 79.20 ? forecast < 79.30 B) 79.60 ? forecast < 79.70 C) 80.10 ? forecast < 80.20 D) 81.95 ? forecast < 82.05 A) 79.20 ? forecast < 79.30 B) 79.60 ? forecast < 79.70 C) 80.10 ? forecast < 80.20 D) 81.95 ? forecast < 82.05

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 is the 2-month weighted moving average forecast for month 3 using the weight in the spreadsheet? Associate weight w1 with sales in time period 2 and w2 with sales in time period 1.

A) 72.44 B) 75.00 C) 76.59 D) 77.56 A) 72.44 B) 75.00 C) 76.59 D) 77.56

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

A) =AVERAGEB9:B12)/4 B) =AVERAGEB7+B10) C) =AVERAGEA9:A12) D) =AVERAGEB9:B12) A) =AVERAGEB9:B12)/4 B) =AVERAGEB7+B10) C) =AVERAGEA9:A12) D) =AVERAGEB9:B12)

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 Excel command can be used in cells F4:F14 in lieu of a formula based on the regression statistics?

A) =TREND$E$3:$E$14,$C$3:$C$14,C4) B) =TREND$E$3:$E$14,$C$3:$D$14,C4:D4) C) =TREND$E$3:$E$14,$C$3:$D$14,D4) D) =TREND$E$3:$E$14,$B$3:$D$14,B4:D4) A) =TREND$E$3:$E$14,$C$3:$C$14,C4) B) =TREND$E$3:$E$14,$C$3:$D$14,C4:D4) C) =TREND$E$3:$E$14,$C$3:$D$14,D4) D) =TREND$E$3:$E$14,$B$3:$D$14,B4:D4)