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»:
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
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
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
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
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,
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
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
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
jPDFWriter jPDFWriter is a Java class library that allows you to create PDF documents without any modifications to your printing code. By extending the standard Java classes that handle printing, jPDFWriter emulates a Java printer job and its behavior. This eliminat
NavControlX NavigationControlX is a Microsoft .Net 2.0 composite control used as a record navigation control with tape machine style buttons. Allows for dual speed fast scrolling in either direction and includes buttons for First, Next, Fast Forward, Fast Reverse, Pre
dbExpress driver for SQL Server dbExpress is a database-independent layer that defines common interface to provide fast access and high performance database connectivity to SQL Server from Delphi and C++Builder on Windows for both 32-bit and 64-bit platforms. For this server dbExpress pr
ChartingControl.NET ChartingControl.net offers the most affordable charting control, built with 100% managed code and the C# language. ChartingControl.net has versions for both WebForms (ASP.NET) and WindowsForms. Main features: .NET Framework 2.0 support, .NET Framework 1.1
Windows Mobile 6 SDK Professional The Windows Mobile 6 SDKs add documentation, sample code, header and library files, emulator images and tools to Visual Studio that let you build applications for Windows Mobile 6.
With Windows Mobile 6, we are revising our SKU taxonomy and naming to be
CDBFAPI Powerful library for working with DBF files. The library does not require any ADO/BDE/ODBC or other drivers, which allows for much easier configuration and a great deal of confidence that your program will run properly on most Windows platforms. When you w
TWallPaper A graphic control which can display bitmaps, icons, metafiles, JPEG files and GIF files in various ways.Image can be positioned : topleft, topright, bottomleft, bottomright, centered, tiled or stretched.
Telerik RadComboBox Telerik RadComboBox is a powerful drop-down list control with internal AJAX-based load-on-demand mechanism for superior performance in heavy-data scenarios. The product introduces a number of advanced features like multi-item autocomplete, grid-like multip
WPF Softphone for VB.NET Ozeki .Net SIP SDK for developing Windows Forms softphone in VB.Net to implement VoIP calls. The sample program allows to make/receive calls, handles DTMF signals to navigate in IVR systems. It is customizable with more features and company logo. It is com
Supported Operating Systems:
Windows XP |
Comments on :
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