Question 9 (1 point) 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 IC 1 Number of 4-Month 2 Time Period Cars Sold Moving Avg. 13 1 170 4 2 80 5 3 166 16 4 74 17 5 64 8 6 76 71.00 197 72 70.00 (108 82 71.50 119 82 73.50 12.10 176 78.00 1311 84 78.00 1412 80 81.00 1513 1614 17 18. MSE 40.59 What formula should be entered in cell C13 to compute the 4-month moving average forecast for month 11? =AVERAGE(B9:B12)/4 =AVERAGE(A9:A12) =AVERAGE(B7+B10) =AVERAGE(B9:B12)