How to program with this problem

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

Paul Robinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top