title: Calculate Percentile in Excel 2010
body: <p>This is my below list. I am trying to calculate 95% of calls came back in how many millseconds.</p>
  
  <pre><code>Milliseconds   Number of Calls
      45         14
      46         33
      47         40
      48         41
      49         83
      50         114
      51         124
      52         82
      53         89
      54         99
      55         82
      56         72
      57         80
      58         101
      59         73
      60         74
      61         81
      62         64
      63         70
      64         61
  </code></pre>
  
  <p>What does above data means is-</p>
  
  <pre><code>14 calls came back in 45 milliseconds
  33 calls came back in 46 milliseconds
  40 calls came back in 47 milliseconds
  etc etc
  </code></pre>
  
  <p>Now I am supposed to find out <code>95% percentile</code> from the above data. Meaning 95% of time, calls came back in this milliseconds.</p>
  
  <p>Can anyone tell me how to do this in Excel Sheet? Thanks for the help</p>
  
  <p>I am using Excel 2010. I have copied both the columns in my Excel Sheet as it is to calculate the percentage.</p>
  
  <p><strong>Update:-</strong></p>
  
  <p>With the below list, I am getting <code>95 percentil</code>e as 66. So that means 95% of time, calls came back in <code>66 milliseconds</code> which is not right I guess. It looks to me 95% of time, calls came back in ~4ms.</p>
  
  <pre><code>Milliseconds    Number of calls
      0           11
      1           259
      2           504
      3           293
      4           38
      5           15
      6           1
      7           4
      8           1
      9           1
      10          1
      11          2
      23          1
      30          1
      39          1
      147         1
  </code></pre>
  
  <p>I am using this formula- </p>
  
  <pre><code>=PERCENTILE(IF(TRANSPOSE(ROW(INDIRECT("1:"&amp;MAX(B$2:B$21))))&lt;=B$2:B$21,A$2:A$21),0.95)
  </code></pre>