SQLStatistics

Rating: No reviews yet
Downloads: 1640
Released: Apr 28, 2013
Updated: Apr 28, 2013 by cgsouthey
Dev status: Stable Help Icon

Downloads

Documentation Documentation in HTML format (zipped)
documentation, 915K, uploaded Apr 28, 2013 - 121 downloads
Documentation Documentation in PDF format
documentation, 894K, uploaded Apr 28, 2013 - 675 downloads
Application SQLStatistics2008 as install script
application, 415K, uploaded Apr 28, 2013 - 329 downloads
Application SQLStatistics2005 as install script
application, 472K, uploaded Apr 28, 2013 - 53 downloads
Application SQLStatistics2005 Extended Edition (needs SQLCore) as install script
application, 515K, uploaded Apr 28, 2013 - 38 downloads
Application SQLStatistics2008 as Assembly Manager library
application, 284K, uploaded Apr 28, 2013 - 129 downloads
Application SQLStatistics2005 as Assembly Manager library
application, 320K, uploaded Apr 28, 2013 - 41 downloads
Application SQLStatistics2005 Extended Edition (needs SQLCore) as Assembly Manager library
application, 335K, uploaded Apr 28, 2013 - 38 downloads
Application SQLStatistics2008 as raw dll
application, 190K, uploaded Apr 28, 2013 - 134 downloads
Application SQLStatistics2005 as raw dll
application, 192K, uploaded Apr 28, 2013 - 40 downloads
Application SQLStatistics2005 Extended Edition (needs SQLCore) as raw dll
application, 193K, uploaded Apr 28, 2013 - 42 downloads

Release Notes

SQLStatistics extends and enhances your Transact-SQL programming environment by adding 87 powerful new functions and aggregates that add up to the fastest, easiest to use and most comprehensive statistical analysis toolkit for Microsoft SQL Server available today. Functions include:
  • A portfolio of 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; the Fisher transformation; and the Z-test.
  • A broad range of descriptive statistics including geometric, harmonic and quadratic means; truncated and inter-quartile means and the tri-mean; modes of both continuous and discrete data; medians, quartiles, percentiles, percentile rank and absolute rank; skewness and kurtosis; weighted averages, variances, standard deviations and power means; range, mid-range, inter-quartile range, nth largest, nth smallest and more.
  • A comprehensive set of complete and partial beta and gamma functions and their inverses, complements and derivatives.
  • Many others including confidence tests using both normal and Student's-T distributions; functions for linear and exponential regression and extrapolation, including forecasting, error estimation, slope and intercept estimation; combinations and permutations; sum of squared deviations; normalization and more

Reviews for this release

No reviews yet for this release.