MYSQL new feature
The aggregating functions std and variance calculate
the population standard deviations and variance. I
work extensively with datasets doing statistical
analysis. Many times it is faster and more efficient
to perform the basic univariate statistics on the
server but I need the sample standard deviation and
variance. The differences in the sample and
population statistics is the divisor. The population
divisor is the count() of the records, the sample is
the count()-1 of the records. These functions are
STDDev (sample),STDDEVp(population), VAR(sample),
VARP(population) in excel.
I can get the sample statistic by creating a column
and in the select statement do
Would anyone else like this feature?
=====
A man is not the center of his universe, rather those he loves are. So his focus
should always be on them for they will provide him with love and happiness all of his
life - Anonymous
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
