SQLStatistics extends the T-SQL scripting environment
so you can carry out statistical tests, calculate
metrics and perform analyses on your data from within
the database itself. This tends to be much faster and
more efficient than transporting the data across the
network to a client application, and also allows
simpler and cleaner application architectures.

The functions can be used within your T-SQL scripts
and stored procedures in exactly the same way as built-
in T-SQL functions such as SUM, MAX, STDEV etc, and
are equally as fast even across large datasets.

Functions include the following:

- Tests and metrics of correlation, similarity or
dependence between datasets, including chi-squared
tests of independence and goodness of fit; covariance
metrics; F-tests to compare variances; paired and
unpaired Student's-T tests to compare means; Pearson's
product moment correlation coefficient and its square;

Download (522 KB) Website Link to this page