Correct The mean (average) depends on the distribution. If the distribution is either positively or negatively skewed, then the median will not equal the mean. The median of an ordered list is the middle value if the number of elements is odd. If the number of elements is even, then the median is the average of the two middle values.
>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 Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [EMAIL PROTECTED] --------------------------------------------------------------------- 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
