SQLStatistics 1.0.0.0

Works with Windows Vista
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; the Fisher transformation; and the Z-test.

- Descriptive statistics such as geometric, harmonic and quadratic means; truncated and inter-quartile means and the tri-mean; modes of 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.

- Complete and partial beta and gamma functions and their inverses, complements and derivatives.

- Confidence tests using normal and Student`s-T distributions.

- Functions for linear and exponential regression and extrapolation, forecasting, error estimation, slope and intercept estimation.

- Combinations and permutations.
Type : Shareware ($199.00) » EULA
OS Support : Windows All + Vista
Date stamp / Size : Jun, 6. 2011 / 522 kBytes
Asked : SQL Server 2005 or later
Users' value : - Write a Review
Download SQLStatistics fileNo active image buttonNo active image button
Update history of SQLStatistics
v1.0.0.0 (May, 15. 2011)
New release
Distribution permissions for SQLStatistics
The trial version of SQLStatistics can be freely distributed over the internet in an unchanged form
Featured SQLStatistics 1.0.0.0 Vista Files

...SQL scripting environment with...significant challenge in SQL Server. All the...nth previous. - Average (mean), variance (sample...rank. - Exponential average (mean), exponential variance,...standard deviation. - Weighted average, weighted variance...(sample & population), weighted standard deviation (sample...

...is a light weighted and robust tool...text editor, an sql console and a...couple of sql utilities. You can...about the current sql statement. * SQL...information about database statistics and timing. *...

...SQL is a program...analyse your web-site statistics more efficiently. Log2SQL...an existing Microsoft SQL Server database using...built-in native MS SQL support 2) Generate...SQL is distributed as...

...to convert MS SQL databases into MS...(1) all MS SQL data types and...engine (10MB MS SQL database - in...5 minutes on average P-III system) (5)...merges MS SQL data into an...

...MS SQL Repair Software works...instantly for MS SQL recovery process and...for repair MS SQL database like user...triggers, etc. MS SQL Repair SysTools SQL...quickly repair corrupt SQL database and also...for MS SQL database repair process...version of MS SQL Repair Software for...SQL you can easily...