There seems to be confusion over the term MEDIAN. Here are some definitions I found to be very clear.
MEDIAN is one type of average, found by arranging the values in order and then selecting the one in the middle. If the total number of values in the sample is even, then the median is the mean of the two middle numbers. The median is a useful number in cases where the distribution has very large extreme values which would otherwise skew the data. MEAN is one type of average, calculated by dividing the sum of a set of values by the number of values. Dennis McGrath ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Fitts, David A. Sent: Monday, December 07, 2009 9:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Calculate the Median Hi, I don't think there is a median function but I think you can use use the (max(list)) and (min(list)) functions to get the highest and lowest values and then just divide by 2. Regards, Dave Fitts State of Maine Risk Management Division ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Roberts, Jennifer Sent: Monday, November 30, 2009 12:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Calculate the Median Hello, Does anyone know if RBASE has a function to calculate the median of a list of values? I do not see one in my help but that doesn’t mean I haven’t overlooked it. ☺ Thank you, Jennifer Roberts Business Applications Specialist Ohio Masonic Home Phone: 937.525.3080 Fax: 937.505.4009 Ext: 5788 This electronic message contains information from the Ohio Masonic Home, its operating subsidaiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute orotherwise use of this transmission or its contents. If you have received this transmission in error, please notify the Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
