Return-Path: X-Original-To: apmail-commons-issues-archive@minotaur.apache.org Delivered-To: apmail-commons-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9835B117A8 for ; Fri, 27 Jun 2014 17:48:25 +0000 (UTC) Received: (qmail 96627 invoked by uid 500); 27 Jun 2014 17:48:25 -0000 Delivered-To: apmail-commons-issues-archive@commons.apache.org Received: (qmail 96501 invoked by uid 500); 27 Jun 2014 17:48:25 -0000 Mailing-List: contact issues-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: issues@commons.apache.org Delivered-To: mailing list issues@commons.apache.org Received: (qmail 96188 invoked by uid 99); 27 Jun 2014 17:48:24 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jun 2014 17:48:24 +0000 Date: Fri, 27 Jun 2014 17:48:24 +0000 (UTC) From: "Venkatesha Murthy TS (JIRA)" To: issues@commons.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (MATH-1120) Need Percentile computations that can be matched with standard spreadsheet formula MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/MATH-1120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venkatesha Murthy TS updated MATH-1120: --------------------------------------- Attachment: (was: 27-jun-refactored-pivot+nanchanges.patch) > Need Percentile computations that can be matched with standard spreadsheet formula > ---------------------------------------------------------------------------------- > > Key: MATH-1120 > URL: https://issues.apache.org/jira/browse/MATH-1120 > Project: Commons Math > Issue Type: Improvement > Affects Versions: 3.2 > Reporter: Venkatesha Murthy TS > Labels: Percentile > Fix For: 4.0 > > Attachments: 18-jun-percentile-with-estimation-patch, excel-percentile-patch, percentile-with-estimation-patch, r-output.txt > > Original Estimate: 504h > Remaining Estimate: 504h > > The current Percentile implementation assumes and hard-codes the quantile pth position as > p * (N+1)/100 and provides a kth selected value. > However if we need to verify compare/contrast with standard statistical tools such as say MS Excel; it would be good to provide an extensible way of morphing this selection of position than hard code. > For example in order to generate the percentile closely matching with MS Excel the position required may be [p*(N-1)/100]+1. > Please let me know if i could submit this as a patch. -- This message was sent by Atlassian JIRA (v6.2#6252)