The problem is that:
Based on VBAfM, Chris Albright). The file Errors2.xls contains a time
series of
monthly sales in column A and a series of monthly forecasts in column
B. Write
a function called MAPE that finds the mean absolute percentage error
of the
forecasts. For example, the absolute percentage error in row 2 is |713
– 738|/713
= 0.035 or 3.5%. Write this function so that it works with any two
ranges of
observations and corresponding forecasts. Then try it out by entering
the
appropriate formula in cell E1.
There are 2 columns of number in Columns A and B. The excat number
does no matter.
Use the Function to output an column by pressing Ctrl+Shift+Enter.