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 :)

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. 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!