1 Reply Latest reply on Mar 29, 2013 4:16 PM by philmodjunk

    Is there a calculation for percentile

    jconner99

      Title

      Is there a calculation for percentile

      Post

           I have 10 numbers and need to calculation the 50th percentile. Can this be calulated?

        • 1. Re: Is there a calculation for percentile
          philmodjunk

               A quick google search on Percentile produces this formula:

               Percentile = ( NumbValues Below X / Numb values ) * 100

               Rearranging that produces:

               NumbValues * Percentile/100 = Numb values Below X

               so if you have 10 numbers and 50th percentile, you get 5. That means that if you sort your values in ascending order, the first 5 values make up the 50th percentile.

               Is that what you had in mind?