gt; On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote:
>
>> How can I calculate the mean/median/mode from a set of data using
SQL?
>
>
> After a bit of googling, I found this link:
> http://mysql.progen.com.tr/doc/en/Group_by_functions.html
> and a few an
Mike Johnson wrote:
From: Robert Citek [mailto:[EMAIL PROTECTED]
Hello all,
How can I calculate the mean/median/mode from a set of data using SQL?
Mean seems to exist as the average (avg):
select name, avg(value) from table group by name
Is there a way to calculate median and mode with a
On Friday, December 5, Robert Citek wrote:
On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote:
How can I calculate the mean/median/mode from a set of data using SQL?
After a bit of googling, I found this link:
http://mysql.progen.com.tr/doc/en/Group_by_functions.html
and a few
On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote:
How can I calculate the mean/median/mode from a set of data using SQL?
After a bit of googling, I found this link:
http://mysql.progen.com.tr/doc/en/Group_by_functions.html
and a few answers in the comments towards the bottom
From: Robert Citek [mailto:[EMAIL PROTECTED]
> Hello all,
>
> How can I calculate the mean/median/mode from a set of data using SQL?
>
> Mean seems to exist as the average (avg):
>select name, avg(value) from table group by name
>
> Is there a way to calculate medi
Hello all,
How can I calculate the mean/median/mode from a set of data using SQL?
Mean seems to exist as the average (avg):
select name, avg(value) from table group by name
Is there a way to calculate median and mode with a group by clause?
Median: the value at which 50% of the samples are
