I\'m having trouble using excel solutions to solve these problems. I understand

Question

I'm having trouble using excel solutions to solve these problems. I understand MAE and MSE, but I don't know how to convert that to excel terms?

alpha- 0.2 error 2 t actual Forecast calculatio 110 98 120 132 361 1553204 174 2938 FIGURE 5 75 115 198 8 6116 22111067 forecast= 244 4082 =MSE Suppose that you want use solver to find the optimal value for alpha in Figure 5. 24. What address should go into box 1 (set to)? 25. Which radio button would you set? 26. What address should go into box 2 (changing cells)? 27. (2) What constraints should go into box 3 (subject to)?

Explanation / Answer

24. Set the target cell equal to the value of MAD

25. Select minimize.

26. Set the By Changing Cells equal to alpha

27. (2) Add Alpha <= 1 and add Alpha >= 0

After Solver finds a solution select OK to keep the solution.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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