I have a large data set where the data is delineated by a field called "Category." For each Category, I'd like to calculate the PERCENTILE.INC for each row within that Category. For example, here is some sample data with the (manual) formula. I'd like a way to automatically calculate the range variable because I need to run PERCENTILE.INC for many hundreds of Categories and each one has a different range length. (I'm on Windows 7, Excel 2010)
<tbody>
</tbody>
A | B | C | D | |
1 | Category | ID | Impact | CALC |
2 | ACOUSTICS | 01 | 0.365 | =PERCENTILE.INC(C2:C6,[@[Impact]]) |
3 | ACOUSTICS | 02 | 0.721 | =PERCENTILE.INC(C2:C6,[@[Impact]]) |
4 | ACOUSTICS | 03 | 1.022 | =PERCENTILE.INC(C2:C6,[@[Impact]]) |
5 | ACOUSTICS | 04 | 0.912 | =PERCENTILE.INC(C2:C6,[@[Impact]]) |
6 | ACOUSTICS | 05 | 0.393 | =PERCENTILE.INC(C2:C6,[@[Impact]]) |
7 | AGRONOMY | 06 | 1.227 | =PERCENTILE.INC(C7:C9,[@[Impact]]) |
8 | AGRONOMY | 07 | 2.001 | =PERCENTILE.INC(C7:C9,[@[Impact]]) |
9 | AGRONOMY | 08 | 0.991 | =PERCENTILE.INC(C7:C9,[@[Impact]]) |
<tbody>
</tbody>
Last edited: