Trend Line - Regression

[elbojpb]

Within CF, is there a pre-defined function, function method or UDF available that will create a trend-line based on regression analysis on a cfquery result?

Thanks in advance!

[insuractive]

I'm not sure about CF, but you could probably do something like that by leveraging the Excel API through COM or maybe even Jakarta POI. Of course, the downside would be you would have to have excel installed on your server and your finished graphs would not be displayable inline in non Microsoft OS's.

[Newsgroup_User · Accepted solution]

elbojpb wrote:
> Within CF, is there a pre-defined function, function method or UDF available
> that will create a trend-line based on regression analysis on a cfquery
> result?

have a look at the regression CFC here: http://www.cfczone.org/cfcs/index.cfm

[elbojpb]

That's the ticket ... many many thanks.