Refer to Figure 4. What EXCEL FORMULA goes in cell A? =SUM(G11:G13)/3 =ABS(E13-B

Question

Refer to Figure 4. What EXCEL FORMULA goes in cell A?

=SUM(G11:G13)/3

=ABS(E13-B13)

=(B7*2+B6+B5)/4

=4*(G10:G13)

=(B13*C5+B12*C4+B11*C3)/C15

=AVERAGE(G6:G13)

=ABS(G12-G13)/2

=SUM(G11:G13)/3

=ABS(E13-B13)

=(B7*2+B6+B5)/4

=4*(G10:G13)

=(B13*C5+B12*C4+B11*C3)/C15

=AVERAGE(G6:G13)

=ABS(G12-G13)/2

Figure 4. The following spreadsheet shows a 3-period weighted average forecasting model used to forecast demand for bags of fertilizer. 1 Historical data Forecast Error Analysis Absolute Squared Absolute Bags Weights Forecast Error error Year error 4000 1. 6000 4000 2 4500 500 5000 250000 10.00% 5 5000 5000 5000 25000000 50.00% 10000 6 8000 AA 750 750 562500 9.38% 7000 7750 750 750 562500 10.71% 10 8 B 1000000 9000 8000 1000 1000 11 9 8250 3750 3750 14062500 31.25% 12000 12 10 4000 16000000 28.57% 14000 10000 E 15000 13 11 12250 2750 2750 7562500 18.33% D L C 8125000.000 21.17% 14 Next period MSE MAPE 15 sum of weights MAD

Explanation / Answer

as above is to calcujalte last 3 month weighted average

hence forecast =(2*last month actual+1*prior to last month actual +1* 2 month prior actual)/4

hence =(B7*2+B6+B5)/4

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.