question

Vignesh_Kumar_Cbe avatar image
Vignesh_Kumar_Cbe asked

Multiple linear Regression in SQL Server

I have developed Simple Linear regression function in SQL Server from here ( https://ask.sqlservercentral.com/questions/96778/can-this-linear-regression-algorithm-for-sql-serve.html) to calculate Alpha,Beta and some extra values like Upper 95% and Lower 95%. The Simple Linear regression takes the argument as X and y. Now I am in need of perform Multiple Linear regression SQL Server, which takes arguments y and X1,X2,X3,.....Xn Anyone can please suggest me a good way to achieve this.
sql-serverlinear-regression
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
This is not something I've done, but there are a [number of articles][1] and blog posts available [on this topic.][2] There are also articles available [on our sister site][3]. [1]: http://westclintech.com/Blog/tabid/132/EntryId/83/Multiple-linear-regression-in-SQL-Server.aspx [2]: http://westclintech.com/Blog/tabid/132/EntryId/101/Fast-Multiple-Linear-Regression-in-SQL-Server.aspx [3]: http://www.sqlservercentral.com/articles/110116/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.