Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with an estimating program | Excel Programming | |||
The program have the same problem | Excel Programming | |||
Problem with a program code | Excel Programming | |||
vba program problem | Excel Programming | |||
How to program to resolve the following problem. ..thx | Excel Programming |