Index >> Development >> Components & Libraries >> SQLStatistics
Report SpywareSQLStatistics 1.0.0.0
Can not display screenshot
Software Description:
SQLStatistics - Statistics function library for MS SQL Server
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.
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.
100% Clean:
SQLStatistics 1.0.0.0 is 100% cleanThis download (SQLStatistics.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.
Related Software:
- Neat Wizards 1.1.100 - High-quality images for creating professional user wizards and dialog boxes.
- SharpShooter Collection 6.4 - Data processing, analysis and visualization components for .NET in one package.
- EaseSoft PDF417 Barcode .NET Control 3.5.0 - EaseSoft PDF417 Barcode .Net Control support printing and images output
- EaseSoft PDF417 Barcode ASP.NET Control 4.0.0 - EaseSoft PDF417 ASP.NET Web ServerControls generate the barcodes dynamically.
- EaseSoft DataMatrix ASP.NET Web Control 4.0.0 - EaseSoft DataMatrix ASP.NET Web Controls generate the barcodes dynamically.
- EaseSoft DataMatrix Barcode .NET Control 3.5.0 - EaseSoft DataMatrix Barcode .Net Control support printing and images output
- EaseSoft Barcode .Net Control 3.5.0 - EaseSoft Linear Barcode Windows Form Controls support most barcode symbologies
- EaseSoft ASP.NET Barcode Control 4.0.0 - EaseSoft Linear Barcode Web Controls support most barcode symbologies
- SkinCrafter.NET 3.3.4 - Developer, try SkinCrafter.Net and enjoy a new look and feel of your software!
- Html2image Linux 2.0.2014.1228 - Convert html to bmp, png, jpg and jpeg on Linux
top 10 most downloaded
recommended software
-
- HelpSmith
- HelpSmith is an innovative help authoring tool which allows you to create CHM Help files, Web Help , Word RTF, and Manuals from a single source. The r...
-
- EditPlus
- EditPlus is a text editor, HTML editor, PHP editor and Java editor for Windows. While it can serve as a good Notepad replacement, it also offers many ...
