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.How is a quadratic term added to the problem if we want to develop a quadratic trend model?

A) Add a column containing Time2. B) Add a column containing Actual Sales2. C) Increase the Input X Range in the Regression command settings dialog box. D) Square the coefficient for Time in the regression model. A) Add a column containing Time2. B) Add a column containing Actual Sales2. C) Increase the Input X Range in the Regression command settings dialog box. D) Square the coefficient for Time in the regression model. A

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

A) =AVERAGEB12:B15) B) =AVERAGEB12:B15)/4 C) =TRENDB12:B15) D) =B14 A) =AVERAGEB12:B15) B) =AVERAGEB12:B15)/4 C) =TRENDB12:B15) D) =B14

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

A) =$J$3*D7-D3)+ 1-$J$3)*E6 B) =$J$3*D7-D6)+ 1-$J$3)*E6 C) =$J$4*D7-D3)+ 1-$J$4)*E6 D) =$J$4*D7-D6)+ 1-$J$4)*E6 A) =$J$3*D7-D3)+ 1-$J$3)*E6 B) =$J$3*D7-D6)+ 1-$J$3)*E6 C) =$J$4*D7-D3)+ 1-$J$4)*E6 D) =$J$4*D7-D6)+ 1-$J$4)*E6

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 formula should be entered in cell C6 to compute the 2-month weighted moving average forecast for month 3?

A) =F3*B4+F4*B3 B) =$F$3*B4+$F$4*B3 C) =B3+B4)/2 D) =SUMPRODUCT$F$3:$F$4,B3:B4) A) =F3*B4+F4*B3 B) =$F$3*B4+$F$4*B3 C) =B3+B4)/2 D) =SUMPRODUCT$F$3:$F$4,B3:B4)

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

A) 1170 ? predicted sales < 1175 B) 1310 ? predicted sales < 1315 C) 1460 ? predicted sales < 1465 D) 1615 ? predicted sales < 1620 A) 1170 ? predicted sales < 1175 B) 1310 ? predicted sales < 1315 C) 1460 ? predicted sales < 1465 D) 1615 ? predicted sales < 1620

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 root mean squared error in cell C18 of the spreadsheet?

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