Uploaded image for project: 'Commons Math'
  1. Commons Math
  2. MATH-1120

Need Percentile computations that can be matched with standard spreadsheet formula

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.2
    • Fix Version/s: 3.4
    • Labels:

      Description

      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.

        Attachments

        1. r-output.txt
          5 kB
          Venkatesha Murthy TS
        2. percentile-with-estimation-patch
          77 kB
          Venkatesha Murthy TS
        3. math-1120-removeAndSlice.patch
          7 kB
          Venkatesha Murthy TS
        4. excel-percentile-patch
          11 kB
          Venkatesha Murthy TS
        5. 27-jun-refactored-kth-pivoting.patch
          68 kB
          Venkatesha Murthy TS
        6. 18-jun-percentile-with-estimation-patch
          85 kB
          Venkatesha Murthy TS

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              vmurthy Venkatesha Murthy TS
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 504h
                504h
                Remaining:
                Remaining Estimate - 504h
                504h
                Logged:
                Time Spent - Not Specified
                Not Specified