Article View: borland.public.cppbuilder.nativeapi
Article #2339LINEST
From: Dan
Date: Wed, 14 Mar 2007 20:18
Date: Wed, 14 Mar 2007 20:18
18 lines
1529 bytes
1529 bytes
Hi guys, Probably not a NativeAPI function question, but anyway; I am being tasked to reproduce some of the power that is in the Excel LINEST function in an application. I realize that LINEST uses linear regression and least squares; but I am by no means a math major, the Numerical Recipes in C book has been mildly helpful; but I am still stuck without a solution. I can't use OLE to automate Excel as the application may not always be ran on a PC with Excel. Anyone know any great libraries I could use that allow me to import a data set of X and Y values which will return me the best polynomial fit line, or array of A values for the equation y = A1x^2 + A2x + A3? Dan
Technical Details
Message-ID:
<45f85907@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon02.news.prodigy.net!prodigy.net!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10cc67,ba2c79fadc36c43d,start X-Google-Attributes: gid10cc67,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Wed, 14 Mar 2007 15:18:52 -0500 From: Dan <Dan@do.not.spam> User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.nativeapi Subject: LINEST Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 216.174.165.174 Message-ID: <45f85907@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1173903623 216.174.165.174 (14 Mar 2007 13:20:23 -0800) Lines: 18 Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon02.news.prodigy.net!prodigy.net!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail