Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Quarter Year Applications 1 1 96 2 1 114 3 1 112 4 1 81 1 2 97 2 2 103 3 2 120 4 2 99 1 3 105 2 3 110 3 3 117 4 3 96 1 4 74 2 4 94 3 4 100 4 4 96 1 5...

QuarterYearApplications

1196

21114

31112

4181

1297

22103

32120

4299

13105

23110

33117

4396

1474

2494

34100

4496

1595

25122

35113

45100

16102

2696

36116

4698

d.Use the solver function in excel to optimize the smoothing constant in order to generate a minimum MAPE value.

e.Use multiple regression to develop an equation that can be used to predict future applications for home mortgages (hint: use dummy variables for the quarters and create time for the quarter numbers)

  the solver function/ what parameters to type in and to where

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question