Statistics in SQL (Sample Chapter)
By Bill Graziano
on 27 May 2002
| 3 Comments
| Tags: Queries
Ales Spetic submitted "While SQL was never designed to be a statistics package, the language is quite versatile and holds a lot of hidden potential when it comes to calculating statistics. If you need a fast, easy-to-use tool for quick analysis of an existing data set, then the concepts presented in this article may prove quite helpful. The text covers topics like: Means, Modes, Medians Standard deviations, Variances, Standard errors. Confidence intervals, Correlations, Moving averages, Weighted moving averages." Follow the link to Statistics in SQL (Sample Chapter)...