median (Websters) 1. being in the middle; medial, middle. 2. Statistics. Designating a point so chosen in a series that half of the individuals in the series are on one side of it, and half on the other. To illustrate the distinction between median and average, suppose five persons have wages respectively of $3, $4, $5, $7 and $11. The average wage is $6; the median wage is $5.
What statistical distribution is going to change the median from $5? What is the dependency? Redundant numbers do not change the median? Roger P.S. In this case I prefer the max function.:) ----- Original Message ----- From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 8:19 AM Subject: Re: median function? > Roger I Martin PhD writes: > > Hi, > > > > Median as a function in sql does not exests that I know of. But if you get a > > resultset ordered by the column of numbers, you can then pick the median at > > the row index=n/2 where n is the total number of values in the column? > > > > Roger > > Nope . > > Median depends on statistical distribution. > > There is one that is valid for sampling distribution, but there are > still many alternatives. > > This is something that could be done as an UDF. > > -- > Regards, > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus > <___/ www.mysql.com > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
