Oct 4, 2011 at 10:32 PM
Edited Oct 4, 2011 at 10:33 PM
I have a database that I need to add some forecasting capabilities for.
The data itself typically follow a trend where the closer I get to zero along X, Y increases towards 100 %.
In my software, I have implemented a basic linear forecast (in red below) method (similar to Excels FORECAST), but the linear forecast gives me inaccurate results
the closer i get to 0 along x
I tried playing with the Charts in Excel and found that If I use a Polynomial trendline (in green below), it's much closer in many cases, especially as x approaches 0
I am looking for some assistance in how I can use Math.NET functions to build the forecast.
Any help would be much appreciated !
This chart was setup in excel like this