Umm does this mean there is no way to do what I need? Is it inappropiate to ask if it'd be difficult for such a function to be added into MySQL if it is the case that this is an impossible thing to do (or even just very challenging)? A median is a very common function to need in accounting I think. Thanks.
*^*^*^* Michael McGlothlin <[EMAIL PROTECTED]> http://mlug.missouri.edu/~mogmios/projects/ On Thu, 29 Nov 2001, Sinisa Milivojevic wrote: > Christopher R. Jones writes: > > 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. > > > > > > Yes, this is correct, but it is still sampling median. > > On the other hand, some non-parametric test might rule out some of the > values, so we are again in the beginning. > > -- > 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
