Return-Path: Delivered-To: apmail-jakarta-commons-dev-archive@www.apache.org Received: (qmail 42351 invoked from network); 9 Mar 2004 06:20:08 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 9 Mar 2004 06:20:08 -0000 Received: (qmail 45149 invoked by uid 500); 9 Mar 2004 06:19:45 -0000 Delivered-To: apmail-jakarta-commons-dev-archive@jakarta.apache.org Received: (qmail 44840 invoked by uid 500); 9 Mar 2004 06:19:43 -0000 Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Developers List" Reply-To: "Jakarta Commons Developers List" Delivered-To: mailing list commons-dev@jakarta.apache.org Received: (qmail 44827 invoked from network); 9 Mar 2004 06:19:43 -0000 Received: from unknown (HELO exchange.sun.com) (192.18.33.10) by daedalus.apache.org with SMTP; 9 Mar 2004 06:19:43 -0000 Received: (qmail 25960 invoked by uid 50); 9 Mar 2004 06:20:24 -0000 Date: 9 Mar 2004 06:20:24 -0000 Message-ID: <20040309062024.25959.qmail@nagoya.betaversion.org> From: bugzilla@apache.org To: commons-dev@jakarta.apache.org Cc: Subject: DO NOT REPLY [Bug 27524] - Percentile calculation is not correct X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT . ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bug.cgi?id=27524 Percentile calculation is not correct ------- Additional Comments From phil@steitz.com 2004-03-09 06:20 ------- Excel is using a different percentile interpolation definition than what [math] currently uses. Unfortunately, the javadoc and test cases describing the [math] algorithm have been inadvertently removed. [math] uses the "index number" method with simple linear interpolation as described in the first example here: http://www.math.bcit.ca/faculty/david_sabo/apples/math2441/section4/relstanding/RelStanding.htm The code is working as designed. The reference above also describes the method used by Excel, which is another commonly used algorithm that gives different results. R uses this method as well. I am +1 to changing to the R / Excel method and will make the change (and add complete javadoc) if there are no objections. --------------------------------------------------------------------- To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-dev-help@jakarta.apache.org