CREATE TEMPORARY VIEW TempV (MedianCol) AS SELECT MedianCol FROM SomeTable ORDER BY MedianCol
SELECT COUNT(*) INTO vCount FROM TempV SET V vUpper INTEGER=(INT(.vCount/2)+1) SELECT MedianCol INTO vMedian FROM TempV WHERE COUNT=.vUpper IF vUpper=(.vCount/2+1) THEN *(even # of values) SET V vLower=(.vUpper-1) SELECT MedianCol INTO vA FROM TempV WHERE COUNT=.vLower SET V vMedian=((.vMedian+.vA)/2) ENDIF Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForensicSystemsGroup.com 416 482 2140 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On > Behalf Of Bob Powell > Sent: June 24, 2002 9:11 AM > To: [EMAIL PROTECTED] > Subject: Finding the median > > Hello everyone: > > Is there a way to determine the median value in a set of number in R:Base. I know > how to get the mean value but I can't seem to find a way to identify the median. > > Bob Powell > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
