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