Note: In order to use the spreadsheet examples, you need to download Business Functions
|Ramp (Time, Base, Dates, AnnualRates, [PolyOrder], [DayCount], [Periods], [ProjMode])|
|Projects amounts in timeperiods where the rates are roughly known at various points in time, and you need a best-fit polynomial curve fitted to the data.|
|Auto Array Function|
When using polynomial curve fitting, there is a minimum goodness of fit criteria built in to the function. If the R squared is below 50%, the function will return an #NUM! error, to protect you from inadvertently using a badly fitted curve.
Polynomial Curve Fitting (ØConnectOptØ>=0): We recommend letting the function choose the best polynomial for you (ØConnectOptØ=0). It will choose the polynomial with the best R squared from the first 20 degrees of order. Choosing your own polynomial degree (ØConnectOptØ>=1) does presuppose that you have some special knowledge about the data that leads you to think that one particular degree is most suitable, and increases your chances of having a failure of the function due to an unacceptably bad goodness of fit.
TemplatesThis function features in the following downloadable spreadsheet template(s):