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»:
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
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
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
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
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
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
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,
Jep.Net Jep.Net is a library for parsing and evaluating mathematical expressions. With this package you can allow your users to enter an arbitrary formula as a string, and instantly evaluate it. Jep.Net supports user defined variables, constants, and functions and
Windows Embedded Standard Windows Embedded Standard delivers the power, familiarity, and reliability of the Windows operating system in componentized form, helping device makers to easily create smart connected devices requiring rich applications, services, and end-user experiences
CMATH for Delphi XE6 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.
UPS Rating Tool UPS offers an XML online tool to obtain Rating Information for their service offerings. However, it is up to the individual company to program and implement. All the work has been done in this DLL. Easily obtain UPS Rates (by either a specific service or r
PPT2SWF SDK ABTO Software's advanced and extremely effective solution, PPT to SWF SDK, provides your applications with an automatic Microsoft PowerPoint to Adobe Flash conversion feature. Our PowerPoint to Flash SDK is efficiently utilized for fast and simple Power Po
OCH Studios - Licensing Our custom build Security Verification System is 'Per-PC' licensing so it is almost impossible to break. Implementing the Licensing system is easy. After refrencing the DLL which we provide to you after purcahse has been completed. 3 Lines of code is all i
CR Pack for 3D GameStudio CR Pack contains 3D GameStudio plugin which runs with your copy of 3DGS, more than 25 functions to work with compressed resources, Windows Explorer add-on which allows the integration of the compressed resources into Windows shell, powerful compressed reso
TagTooga Social Bookmarking ActiveX Social Bookmarking Submit ActiveX Component for del.icio.us, furl.net, simpy.com, tagtooga.com, shadows.com, blogmarks.net, spurl.net, and netvouz.com. Provides a simple API for submitting a URL with title, extended description, and tags.Requirements:Windo
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