How to program with this problem

  • Thread starter Thread starter bear
  • Start date Start date
B

bear

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.
 
Hi
The trick is to disguise homework...no one is going to do your
homework for you!
Paul
 
Back
Top