title: How to calculate 95th percentile in Excel 2010
body: <p>I am trying to calculate how many calls came back in 95 percentile of time. Below is my Result Set. I am working with <code>Excel 2010</code></p>
  
  <pre><code>Milliseconds    Number
  0               1702
  1               15036
  2               14262
  3               13190
  4               9137
  5               5635
  6               3742
  7               2628
  8               1899
  9               1298
  10              963
  11              727
  12              503
  13              415
  14              311
  15              235
  16              204
  17              140
  18              109
  19              83
  20              72
  21              55
  22              52
  23              35
  24              33
  25              25
  26              15
  27              18
  28              14
  29              15
  30              13
  31              19
  32              23
  33              19
  34              21
  35              20
  36              25
  37              26
  38              13
  39              12
  40              10
  41              17
  42              6
  43              7
  44              8
  45              4
  46              7
  47              9
  48              11
  49              12
  50              9
  51              9
  52              9
  53              8
  54              10
  55              10
  56              11
  57              3
  58              7
  59              7
  60              2
  61              5
  62              7
  63              5
  64              5
  65              2
  66              3
  67              2
  68              1
  70              1
  71              2
  72              1
  73              4
  74              1
  75              1
  76              1
  77              3
  80              1
  81              1
  85              1
  87              2
  93              1
  96              1
  100             1
  107             1
  112             1
  116             1
  125             1
  190             1
  356             1
  450             1
  492             1
  497             1
  554             1
  957             1
  </code></pre>
  
  <p>Just some background what does above information means-</p>
  
  <pre><code>1702 calls came back in 0 milliseconds
  15036 calls came back in 1 milliseconds
  14262 calls came back in 2 milliseconds
  etc etc
  </code></pre>
  
  <p>So to calculate the 95th percentile from the above data, I am using this formula in excel 2010-</p>
  
  <p><code>=PERCENTILE.EXC(IF(TRANSPOSE(ROW(INDIRECT("1:"&amp;MAX(H$2:H$96))))&lt;=H$2:H$96,A$2:A$96),0.95)</code></p>
  
  <p>Can anyone help me whether the way I am doing in Excel 2010 is right or not?</p>
  
  <p>I am getting 95th percentile as 10 by using the above scenario.</p>
  
  <p>Thanks for the help.</p>