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.
SQL Server 2005 or later
Like it? Share with your friends!
Other Windows Software of Developer «TotallySQL»:
SQLRollingStats SQLRollingStats extends the T-SQL scripting environment with 31 windowed or cumulative functions (in which results for each row depend on previous rows) that can be used as regular functions in queries.
This allows metrics such as running totals or mov
SQLUtilities SQLUtilities extends the T-SQL scripting environment by adding 64 new general-purpose functions for text, date/time and numeric processing that can be used directly within queries and stored procedures at the database layer.
Date and time functions inc
SQLFinancials SQLFinancials extends the T-SQL scripting environment by adding financial analysis functions similar to those found in the MS Excel analysis toolpack, but which can be used directly within the database.
Performing data analysis from within the database
SQLDistributions SQLDistributions extends the T-SQL scripting environment to by adding support for modelling and analysing probability distributions directly within the database.
Performing data analysis from within the database tends to be much faster and more efficie
SQLEngineering SQLEngineering extends the T-SQL scripting environment to add direct support for technical, engineering and scientific applications at the database layer.
Performing data analysis from within the database tends to be much faster and more efficient than
SQLTuples SQLTuples is a FREE product that adds a number of tuple types and constructor functions within the T-SQL scripting environment that can be used anywhere that a compound type is needed.
Tuples of between 2 and 6 elements can be constructed easily using
SQLMath SQLMath extends the T-SQL scripting environment so you can perform mathematical operations 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,
Assembly Manager Assembly Manager is a windows application aimed at both SQL CLR developers and SQL DBAs that solves the problems of trying to manage CLR assemblies using just Visual Studio or SSMS.
It allows you to see in a tree-structured view all installed CLR assem
Sniper Sniper is a powerful component that helps developers to add key logging functionality in their applications. Sniper is a small ActiveX control that encapsulates all the complexity for logging keys and exposes only a few important properties and methods, wh
TPlanner(Delphi 2006,2007 and C++Builder 2006,2007) TPlanner(Delphi 2006,2007 and C++Builder 2006,2007) is a flexible day, month, week, timeline, multi-day, multi-resource, and custom scheduling user interface component. It has many feature like items that can be resized / repositioned, inplace, multiline
GPS ToolKit.NET GPS ToolKit.NET is a powerful component that makes it easy to add GPS support to any Visual Basic .NET, C#, or C++ project. GPS ToolKit.NET provides access to dozens of data sets, including position, speed, course, satellite, and navigation data. Additiona
Add-in Express for Office and VCL With Add-in Express for Office and VCL you can create powerful, fast, and easy deployable plug-ins for all available Microsoft Office versions, including Office 2010, 2007, 2003, 2002 (XP) and Office 2000. Add-in Express is completely based on the Rapid Ap
Centricorp's Base 64 Encoder-Decoder DLL *Recommended for developers familiar with DLLs. If you are not familiar with DLLs, it is recommended that you use the Base 64 Application. Centricorp's Base 64 Encoder/Decoder DLL is a useful tool for developers. The developer will have the ability to encr
ApPHP DataValidator ApPHP DataValidator is a simple lightweight tool useful for primary general data checks. It handles numbers, strings, emails, URLs. A range of parameters is provided for a wide variety of different verifications. All parameters are used optionally and coul
SabreDAV SabreDAV allows you to easily add WebDAV support to a PHP application. SabreDAV is meant to cover the entire standard, and attempts to allow integration using an easy to understand API. It supports class 1, 2 and 3 Webdav servers, locking support, custom p
EASendMail SMTP Component EASendMail enables your C#, VB.NET, JScript.NET, ASP.NET or other .NET framework applications to send Text/Html email based on SMTP/ESMTP protocol. It is a full-featured component which supports all operations of the SMTP/ESMTP protocol and provides many a
CMATH for Delphi 2010 CMATH is a comprehensive library for complex-number arithmetics and mathematics.
The following features make CMATH an ideal replacement for the unit Complex coming with Delphi:
1. High-performance implementation in machine code leads to superior speed.
Virto URL Shortener Web Part for Microsoft SharePoint Virto URL Shortener Web Part for Microsoft SharePoint automatically cuts large URLs by a single click to short links that can be used instantly by SharePoint users as for sending by e-mail, twitting, and even spelling by phone. It features automatic cut of
Supported Operating Systems:
Windows XP |
Comments on SQLStatistics:
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10