median; adjective:
(statistics) relating to or constituting the middle value of an ordered set of values
(or the average of the middle two in an even-numbered set)
This is the definition of median. It's not a "calculated" value, it's more of a
"derived" value.
>>> [EMAIL PROTECTED] 05/15/01 07:38PM >>>
Another way to compute median is here:
1. You should know that there is a linear relationship between Mean, Median
and Mode. Find that relationship.
2. Find the mean of the data. Its nothing but the average.
3. Next you have find the mode. Mode is nothing but the most frequent
data. suppose, sal is the column for which you want to find the median,
then proceed like this -
select sal, count(*) Number_of_people
from emp
group by sal
order by 2 Desc;
Now the first record returned by the above query represents the mode.
Caputure the sal from this first record and call it as mode.
4. Now, Using the relationship u determined in step 1, calculate the median
values by substituting the mode and mean values.
PS: I know this is going to work is salary is an interger field. But I
doubt it if its a real number.
Listers,letme know if I am wrong. Also, I did not watch earlier mails on
this topic,. so, pardon me if its a repeat.
Rajaram.
-----Original Message-----
From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Mean/Median
HELP
> Are you stupid?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajaram
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
