statistical function
How to write c coding for forecast function in microsoft excel?
You would need to know the method used. Its a kind of curve fitting algorithm. Then it just evaluates the curve for the points that you want.
That means, for instance, that you have payments for every month for the past year. Your X coordinates are the dates each month and the Y coordinates are the dollar amounts. Then you fit a curve to those points and get the Y coordinates for the next 12 X coordinates.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment