Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Regression In SQL

Author  Topic 

hasitha.necromancer
Starting Member

2 Posts

Posted - 2014-09-22 : 07:47:58
how to do the Regression in TSQL with multiple variables

as example

if there X1,x2,x3 variables

how to do the regression and get the intercept

Arun Babu N
Starting Member

26 Posts

Posted - 2014-09-22 : 09:50:52
http://ayadshammout.com/2013/11/30/t-sql-linear-regression-function/

arunbabu
Go to Top of Page

hasitha.necromancer
Starting Member

2 Posts

Posted - 2014-09-23 : 05:31:47
the site which u mentioned there are example for only one X variable, but I need x1,x2,x3 and like that many x variables,
as a example

month sale (Y) price(X1) advertising cost (X2)

1 100 500 400
2 120 400 1000
3 130 600 1500

so I want to forecast 4th month sale how to do this in sql


Go to Top of Page
   

- Advertisement -