commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Venkatesha Murthy TS (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (MATH-1120) Need Percentile computations that can be matched with standard spreadsheet formula
Date Mon, 02 Jun 2014 14:09:01 GMT

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

Venkatesha Murthy TS edited comment on MATH-1120 at 6/2/14 2:07 PM:
--------------------------------------------------------------------

Cleared check style, pmd, findbugs and improved code coverage for the changed portions.

You could also refer to the complete sources at:

https://github.com/venkateshamurthy/java-quantiles/blob/master/src/main/java/org/apache/commons/math3/stat/descriptive/rank/Percentile.java
https://github.com/venkateshamurthy/java-quantiles/blob/master/src/test/java/org/apache/commons/math3/stat/descriptive/rank/PercentileTest.java


was (Author: vmurthy):
Cleared check style, pmd, findbugs and improved code coverage for the changed portions.

> 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: excel-percentile-patch, percentile-with-estimation-patch
>
>   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)

Mime
View raw message