Percentiles

  • Resolved Graicifyd

    (@graicifyd)


    1 year, 7 months ago

    Is there a function in CFF that can be used to calculate percentiles automatically?

    For example, if you have some data: 26, 28, 28, 28, 28, 28, 28, 28, 30, 30 is there a function to calculate what percentile 28 falls within?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @graicifyd

    You must walk the array of numbers and increase a counter for every value below the number “X”, in your example X=28. And finally, evaluate operation:

    (number of values below “X” / number of values)*100

    In your example:

    (number of values below “28” / number of values) * 100 =
    (1/10)*100 =
    10

    If you need that us to implement a PERCENTIL operation you can call from your equations, you can contact us via the plugin website:

    https://cff.dwbooster.com/customization

    Best regards.

    Plugin Author codepeople

    (@codepeople)

    Hello @graicifyd

    If you are referring to the percentilerank, the formula would be:

    PR% = (L + ( 0.5 * S ) / N) * 100

    Where L is the number of values below “X”, S is the number of values equal to “X”, and N the number of all values.

    Continuing with your example:

    PR% = ((1 + (0.5)*7)/10)*100
    = ((1 + 3.5)/10)*100

    PR% = ((1 + (0.5)*7)/10)*100
    = ((1 + 3.5)/10)*100
    = (4.5/10)*100
    = 45

    Best regards

    Thread Starter Graicifyd

    (@graicifyd)

    Hi,

    Thank you so much for the explanation.

    This should work.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Percentiles’ is closed to new replies.