How to program with this problem
 

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.

How to program with this problem
 

Hi
The trick is to disguise homework...no one is going to do your
homework for you!
Paul

On Sep 22, 6:08*am, bear wrote:
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.