SQLStatistics - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQLStatistics by TotallySQL

URLs: sqlstatistics, totallysql

Every kind of statistical test and metric built right into the database layer. SQLStatistics extends and enhances your Transact-SQL programming environment by adding 80+ powerful new functions and aggregates. 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. SQLStatistics also includes 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.

SQLStatistics includes:

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.

Beyond Excel

The functions available in SQLStatistics include numerically faithful equivalents of the familiar statistical functions found in Microsoft Excel and other popular packages, but also many others which - combined with the innate power and ability of SQL Server to rapidly crunch through huge volumes of data - gives you an analytical capability that completely beats anything you could do with spreadsheets.

Native Look and Feel

All TotallySQL Transact-SQL extensions are implemented using familiar programming objects within SQL (scalar and table-valued functions, aggregate functions, user-defined types, stored procedures), keeping the syntax clean and making them as fast and easy to use as the built-in native statistics functions such as SUM, AVG etc.

Outstanding Performance and Numerical Accuracy

The algorithms behind the SQLStatistics functions use industry-proven, best-in-class techniques devised by some of the world's leading numerical computing experts to maximise performance and accuracy even for fairly extreme input values. Careful heuristics and edge-case checks through the code ensure that problems caused by the limitations of floating-point arithmetic on digital computers (such as cancellation errors) are kept to an absolute minimum, and a broad range of special-purpose, high-performance numerical computing approaches are used in place of the slow, expensive computations that would result from 'naive' implementations of the underlying mathematics.

Multi-Valued Aggregates - even in SQL2005

Several of the SQLStatistics functions (for example weighted metrics for average, variance, standard deviation etc) are in the form of aggregate functions that take multiple input values. This works fine for SQL2008 but is commonly supposed to be impossible in SQL2005 - since you can supply only one input parameter to an aggregate function. TotallySQL have, however, devised a very simple but smart way of doing this in SQL2005 using SQLTuples: you simply combine the input parameters (of any type) into a SQLTuples object on-the-fly as part of the function call. Only a very minor syntax change is needed and there is no measurable performance penalty even when used with truly enormous data sets.

SQLStatistics Features:

X2 statistics and tests for goodness of fit to a distribution and for independence of outcomes F-statistic and F-test to compare the variance of two populations

One & two sample (paired & unpaired) Student's T test statistics & results

Z-test statistic & result comparing predicted with observed means

Fisher transformation and its inverse Complete & incomplete beta functions, inverses, complements & beta derivative

Gamma function, lower & upper incomplete gamma functions & inverses, log-gamma, gamma ratios, digamma, gamma derivative

Average absolute deviation, sum of squared deviations

Combinations and permutations Confidence intervals based on Normal and Student's T distributions

Pearson product moment correlation coefficient & its square

Sample and population co-variance of two data sets

Geometric mean, harmonic mean, quadratic mean, truncated mean & weighted power mean

Weighted averages, weighted sample & population variances & standard deviations

Linear & exponential extrapolations for forecasting

Linear regression to determine slope and intercept

Median & quartiles (inclusive & exclusive), interquartile range, interquartile mean, tri-mean

Percentile & percentile rank, inclusive & exclusive

Average & absolute rank

Skewness, kurtosis and kurtosis excess

Range, mid-range, nth largest, nth smallest

Mode for continuous or discrete data

Cumulative product Normalization of values based on supplied mean and standard deviation

Standard error of predicted values based on linear regression

Riemann zeta function for a complex number All functions implemented as straightforward scalar or aggregate functions that can be used inline in queries

Multi-input aggregate functions, even in SQL2005

Every kind of statistical test and metric built right into the database layer.

Pricing: SQLStatistics - CAL (Client Access License) V1.0 1 CAL License, SQLStatistics - CAL (Client Access License) V1.0 5 CAL License, SQLStatistics - CAL (Client Access License) V1.0 10 CAL License, SQLStatistics - CAL (Client Access License) V1.0 25 CAL License, SQLStatistics - CAL (Client Access License) V1.0 50 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 1 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 5 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 10 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 25 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 50 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 1 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 5 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 10 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 25 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 50 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 1 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 5 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 10 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 25 CAL License, SQLStatistics - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 50 CAL License, SQLStatistics CAL (Client Access License) - 1 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 1 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 1 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 1 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 1 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 3 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 3 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 3 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 3 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 3 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 5 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 5 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 5 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 5 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLStatistics CAL (Client Access License) - 5 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLStatistics - CPU License V1.0 1 CPU License, SQLStatistics - CPU License V1.0 2 CPU License, SQLStatistics - CPU License V1.0 4 CPU License, SQLStatistics - CPU License V1.0 8 CPU License, SQLStatistics - CPU License V1.0 Unlimited CPU License, SQLStatistics - CPU

Evals & Downloads: Read the SQLStatistics help file, Read the TotallySQL License Agreement, Download the SQLStatistics V1.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET Class, 100% Managed Code

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005

Keywords: SQLStatistics

totally sql

Math Stats Mathematics Mathematical Statistic Statistical

SQL query language

Part numbers: PC-541710-407631 541710-407631 PC-541710-407632 541710-407632 PC-541710-407633 541710-407633 PC-541710-407634 541710-407634 PC-541710-407635 541710-407635 PC-541710-407636 541710-407636 PC-541710-407637 541710-407637 PC-541710-407638 541710-407638 PC-541710-407639 541710-407639 PC-541710-407640 541710-407640 PC-541710-407641 541710-407641 PC-541710-407642 541710-407642 PC-541710-407643 541710-407643 PC-541710-407644 541710-407644 PC-541710-407645 541710-407645 PC-541710-407646 541710-407646 PC-541710-407647 541710-407647 PC-541710-407648 541710-407648 PC-541710-407649 541710-407649 PC-541710-407650 541710-407650 PC-541710-407651 541710-407651 PC-541710-407652 541710-407652 PC-541710-407653 541710-407653 PC-541710-407654 541710-407654 PC-541710-407655 541710-407655 PC-541710-407656 541710-407656 PC-541710-407657 541710-407657 PC-541710-407658 541710-407658 PC-541710-407659 541710-407659 PC-541710-407660 541710-407660 PC-541710-407661 541710-407661 PC-541710-407662 541710-407662 PC-541710-407663 541710-407663 PC-541710-407664 541710-407664 PC-541710-407665 541710-407665 PC-541710-407911 541710-407911 PC-541710-407912 541710-407912 PC-541710-407913 541710-407913 PC-541710-407914 541710-407914 PC-541710-407915 541710-407915 PC-541710-407916 541710-407916 PC-541710-407917 541710-407917 PC-541710-407918 541710-407918 PC-541710-407919 541710-407919 PC-541710-407920 541710-407920 PC-541710-407921 541710-407921 PC-541710-407922 541710-407922 PC-541710-407923 541710-407923 PC-541710-407924 541710-407924 PC-541710-407925 541710-407925 PC-541710-407926 541710-407926 PC-541710-407927 541710-407927 PC-541710-407928 541710-407928 PC-541710-407929 541710-407929 PC-541710-407930 541710-407930 PC-541710-407931 541710-407931 PC-541710-407932 541710-407932 PC-541710-407933 541710-407933 PC-541710-407934 541710-407934 PC-541710-407935 541710-407935 PC-541710-407936 541710-407936 PC-541710-407937 541710-407937 PC-541710-407938 541710-407938 PC-541710-407939 541710-407939 PC-541710-407940 541710-407940 PC-541710-407941 541710-407941 PC-541710-407942 541710-407942 PC-541710-407943 541710-407943 PC-541710-407944 541710-407944 PC-541710-407945 541710-407945