Hi,
I'm sorry if this has already been answered, I found a few posts about percentrank but none had this exact problem.
I have several lists of integer values (not formulas) with many repeating numbers. I want to calculate a percentile value for each of these numbers making sure that all of the repeating numbers have the same percentile value.
I am having two problems:
As an example I have a list of integers ranging from 1 to 16 with many repeating values. When I calculate the percentiles for the various 16s some of them will return 0.98 and some of them will return 0.983, none of them will return 1. Several of my integers lists have the issue of not returning any 1s.
Any ideas?
Thank-you
Bookmarks