Spreadsheet: 72043d1272731989-calculating-percentiles-from-bin-frequency-data-727533-percentiles-from-binned-data
Sheet: Sheet1

Percentile | Value | Value | Value | Value | Value | Value | Value | Value
0.25 | 0.69 | 0.02 | 0.02 | 0.01 | 0.01 | 0.01 | 0.01 | 0.25
0.75 | 0.76 | 0.09 | 0.11 | 0.07 | 0.04 | 0.04 | 0.05 | 0.75
0.75
[NAME]
Increment | A | B | C | D | E | F | G | G
0 | 0 | 135386 | 111467 | 160019 | 268105 | 264864 | 185913 | 1
0.01 | 0 | 122692 | 102873 | 143884 | 216935 | 215839 | 179221 | 1
0.02 | 0 | 110838 | 94789 | 128428 | 172994 | 173223 | 166064 | 1
0.03 | 0 | 99828 | 87154 | 113778 | 135803 | 136599 | 148187 | 1
0.04 | 0 | 89597 | 79958 | 100016 | 104619 | 105620 | 127336 | 1
0.05 | 0 | 80049 | 73199 | 87202 | 78937 | 79821 | 105291 | 1
0.06 | 0 | 71331 | 66842 | 75411 | 58128 | 58791 | 83018 | 1
0.07 | 0 | 63247 | 60889 | 64657 | 41636 | 42052 | 61604 | 1
0.08 | 0 | 55850 | 55339 | 54921 | 28862 | 29061 | 42460 | 1
0.09 | 0 | 49109 | 50154 | 46205 | 19270 | 19324 | 26723 | 1
0.1 | 0 | 42980 | 45317 | 38490 | 12289 | 12281 | 15116 | 1
0.11 | 0 | 37407 | 40827 | 31708 | 7422 | 7409 | 7511 | 1
0.12 | 0 | 32419 | 36657 | 25811 | 4198 | 4205 | 3163 | 1
0.13 | 0 | 27930 | 32808 | 20738 | 2187 | 2212 | 1087 | 1
0.14 | 0 | 23911 | 29274 | 16418 | 1026 | 1055 | 268 | 1
0.15 | 0 | 20342 | 26005 | 12792 | 416 | 444 | 36 | 1
0.16 | 0 | 17207 | 23021 | 9781 | 136 | 154 | 0 | 1
0.17 | 0 | 14428 | 20286 | 7312 | 31 | 39 | 0 | 1
0.18 | 0 | 12018 | 17811 | 5329 | 4 | 5 | 0 | 1
0.19 | 0 | 9917 | 15558 | 3753 | 0 | 0 | 0 | 1
0.2 | 0 | 8124 | 13520 | 2550 | 0 | 0 | 0 | 1
0.21 | 0 | 6579 | 11684 | 1647 | 0 | 0 | 0 | 1
0.22 | 0 | 5278 | 10044 | 1004 | 0 | 0 | 0 | 1
0.23 | 0 | 4185 | 8584 | 584 | 0 | 0 | 0 | 1
0.24 | 0 | 3266 | 7285 | 309 | 0 | 0 | 0 | 1
0.25 | 0 | 2523 | 6134 | 153 | 0 | 0 | 0 | 1
0.26 | 0 | 1916 | 5132 | 65 | 0 | 0 | 0 | 1
0.27 | 0 | 1430 | 4266 | 25 | 0 | 0 | 0 | 1
0.28 | 0 | 1045 | 3507 | 6 | 0 | 0 | 0 | 1
0.29 | 0 | 746 | 2856 | 2 | 0 | 0 | 0 | 1
0.3 | 0 | 522 | 2300 | 0 | 0 | 0 | 0 | 1
0.31 | 0 | 352 | 1837 | 0 | 0 | 0 | 0 | 1
0.32 | 0 | 232 | 1452 | 0 | 0 | 0 | 0 | 1
0.33 | 0 | 144 | 1129 | 0 | 0 | 0 | 0 | 1
0.34 | 0 | 84 | 859 | 0 | 0 | 0 | 0 | 1
0.35 | 0 | 47 | 648 | 0 | 0 | 0 | 0 | 1
0.36 | 0 | 23 | 482 | 0 | 0 | 0 | 0 | 1
0.37 | 0 | 11 | 353 | 0 | 0 | 0 | 0 | 1
0.38 | 0 | 4 | 248 | 0 | 0 | 0 | 0 | 1
0.39 | 0 | 1 | 168 | 0 | 0 | 0 | 0 | 1
0.4 | 0 | 0 | 112 | 0 | 0 | 0 | 0 | 1
0.41 | 0 | 0 | 74 | 0 | 0 | 0 | 0 | 1
0.42 | 0 | 0 | 46 | 0 | 0 | 0 | 0 | 1
0.43 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 1
0.44 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 1
0.45 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 1
0.46 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1
0.47 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1
0.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.51 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.53 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.54 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.55 | 128 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.56 | 346 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.57 | 798 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.58 | 1594 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.59 | 2959 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.6 | 4996 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.61 | 8127 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.62 | 12431 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.63 | 18110 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.64 | 25209 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.65 | 33376 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.66 | 42616 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.67 | 51928 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.68 | 61250 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.69 | 69522 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.7 | 76183 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.71 | 81139 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.72 | 83579 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.73 | 83876 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.74 | 81776 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.75 | 77592 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.76 | 71467 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.77 | 63743 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.78 | 54841 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.79 | 45247 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.8 | 35440 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.81 | 25941 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.82 | 17640 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.83 | 10868 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.84 | 6008 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.85 | 2867 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.86 | 1061 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.87 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.88 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.93 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.96 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.97 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.98 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
0.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1