Question: solve with excel and showing functions please :) 1 The Victory Plus Mutual Fund of growth stocks has had the following average monthly price for

solve with excel and showing functions please :)
1 The Victory Plus Mutual Fund of growth stocks has had the following average monthly price for the past 10 months: 3 Month 4 un 5 6 7 8 Fund Price 62.7 63.9 68 66.4 67.2 65.8 68.2 69.3 67.2 70.1 1 2 3 4 5 6 7 8 9 10 9 10 11 12 8 13 14 15 17 Compute the exponentially smoothed forecast with a= 40, the adjusted exponential smoothing forecast 18 with a= 40 and = 30 and the linear trend line forecast. Compare the accuracy of the three forecasts, using 19 cumulative error and MAD, and indicate which forecast appears to be most accurate. 20Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
