Mailing-List: contact issues-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: issues@commons.apache.org
Date: Sun, 13 Jul 2014 09:00:13 +0000 (UTC)
From: "Luc Maisonobe (JIRA)" <jira@apache.org>
To: issues@commons.apache.org
Message-ID: <JIRA.12713154.1399575099993.31958.1405242013426@arcas>
In-Reply-To: <JIRA.12713154.1399575099993@arcas>
References: <JIRA.12713154.1399575099993@arcas>
Subject: [jira] [Commented] (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


    [ https://issues.apache.org/jira/browse/MATH-1120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14060050#comment-14060050 ] 

Luc Maisonobe commented on MATH-1120:
-------------------------------------

The patch from June 27th has been applied, with a few changes, as the patch did not include the factored out classes. The classes were therefore extracted from the previous version and API adapted for the select method (which now provides the arrays to work on).

Thanks for the patch

As explained on the mailing list, the problem for FIXED NaNStrategy is still there, and I still want to look at it.

> 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, 27-jun-refactored-kth-pivoting.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)