[ https://issues.apache.org/jira/browse/MATH-1120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14026595#comment-14026595 ]
Venkatesha Murthy TS commented on MATH-1120: -------------------------------------------- Please let me know your opinion on the 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: 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)