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

Need Percentile computations that can be matched with standard spreadsheet formula

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.2
    • 3.4
    • None

    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

            Unassigned Unassigned
            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