Hello,

Anyone having idea about the linear regression functions in SQL 2008 like LINEST in EXCEL? Or any function for SLOPE & INTERCEPT? Or any function created for this will be helpful.

Thanks in advance for any help.

Regards,
Narendra

I think these are not available in SQL server
Please check the following for some of the options:
http://knol.google.com/k/linus-nilss.../g1yluc4toyn/8

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

Thanks Om,

I also got some info on net. Need to create SQL UDF.


set nocount on
declare @n int
create table #lr (x real not null, y real not null)
--insert sample data
insert into #lr values (2005,5.620400866)
insert into #lr values (2006,5.638354669)
insert into #lr values (2007,5.659482216)
insert into #lr values (2008,5.676753802)
insert into #lr values (2009,5.697093487)
select @n=count(*) from #lr --this is just for convenience, you can substitute count(*) for @n in the code
--meat of the code begins here
select
((@n * sum(x*y)) - (sum(x)*sum(y)))/
((@n * sum(Power(x,2)))-Power(Sum(x),2)) AS Slope,
avg(y) - ((@n * sum(x*y)) - (sum(x)*sum(y)))/
((@n * sum(Power(x,2)))-Power(Sum(x),2)) * avg(x) as Intercept
from #lr
drop table #lr