PadRING What are they doing when you are not home??
Download WebCam Spy now!
 
 
 
 
 
 
 
 
 


SQLStatistics

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.




Release date:2011-05-03
Order:Click here to purchase full version
Company:TotallySQL Ltd
Author:Charles Southey
Website:totallysql.com
 
Keywords:sql statistics, sql weighted average, sql bi
 
Program type:Shareware - $199.00
Install support:Install Only
Operating system:WinXP, WinVista, WinVista x64, Win7 x32, Win7 x64, WinServer
 
Requirements:SQL Server 2005 or later
 
Download1:sqlstatistics.zip
Download2: 
File size:522 K

Back to Development/Scripts


Google
  Web www.padring.com
 Copyright © 1999-2011 SoftCab, Inc   (Privacy Policy)   0.0027—0.0006—3