Excel Functions in SQL server2005

Question

Excel Functions in SQL server2005

sthirun

SSC Veteran

Points: 240
More actions
September 1, 2009 at 9:48 am

#138527

I have a function in Excel- LINEST (Linear regression)
need to implement the same in SQl server 2005 if it is already not there( I do not see one)
Any help is greatly appreciated.
Thank you
Sree

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Nabha SSCrazy Eights Points: 8534 More actions · Answer 1

I am just giving it a wild guess, I had not seen that in SQL Server atleast. Lets if someone knows about it. Otherwise what you can do is create a dot net assembly (CLR assembly). I guess it should be there in dot net library. Hope this helps.

---------------------------------------------------------------------------------

Jatin Soni SSC Eights! Points: 933 More actions · Answer 2

Hello,

Did you find any solution to this?

I also need to implement the Excel Linest() function in SQl server 2008.

Lowell SSC Guru Points: 323504 More actions · Answer 3

one of the links here:

http://charlottecredittechnology.blogspot.com/2008/11/sql-2008-excel-like-linest-function.html

seems to have a proc/function that i found after searching for sql server excel linest equivilent

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jatin Soni SSC Eights! Points: 933 More actions · Answer 4

Thanks Lowell,

I have checked the link however I want Multiple Regression. Do you know how to achieve this ?

Lowell SSC Guru Points: 323504 More actions · Answer 5

not offhand, sorry; i only looked briefly at teh psot i showed you, and would have to read up on it;

it really does sound like soemthing i'd put into a CLR instead though.

i found theis link that implies they have a CLR for Linest / liniar regression:http://westclintech.com/XLeratorDBstatisticsDocumentation/tabid/159/Default.aspx

will that do teh job?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!