function libraries, tools and services for Microsoft SQL Server
Login
Register
shopping cart
0 items in cart
Contact Us
Support
Purchase
Download
Services
Products
Home
Home
>
Products
>
SQLStatistics
SQLTuples
SQLUtilities
SQLRollingStats
SQLFinancials
SQLDistributions
SQLEngineering
SQLMath
SQLStatistics
Assembly Manager
SQLStatistics
Every kind of statistical test and metric
built right into the database layer
Overview
Product Features
System Requirements
Pricing & Licensing
Product Documentation
Download Free Trial
X
2
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, n
th
largest, n
th
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
Edit
Request Callback
Buy Online
Download Trial
Talk to Us
Next Steps:
My Account
Privacy Policy
Terms of Use