Statistical SQLCLR routines

SQLCLR Regression routines

This DLL will give you, as developer, the ability to make predictions on your data.
The algorithms in the DLL are based on Least Square Regression methods and will give you the coefficients for the formulas.
You can also see which formula which will give you the best fit, in percentage style.

* Linear regression has 4 formulas

Linear
Exponential
Logarithmic
Power

* Polynomial regression has up to 12 checks, but the most common are

Parabolic (2 checks)
Cubic (3 checks)

You can now have polynomial regression up to (a*x⁰ + b*x¹ + c*x² + … + xⁿ), where n is ranging from 0 to 12

* Spearman's Rank Correlation Coefficient

Here is the DLL
dws.Regression.dll

Here are the install script
Install.sql
Uninstall.sql

Here are the example scripts
Sample1.sql Linear
Sample2.sql Linear
Sample3.sql Polynomial
Sample4.sql Spearman

Email me at peso(at)developerworkshop.net if you have any question, suggestion or improvement.