[ 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)