I need to create a Capita SIMS assessment manager sheet that does the same calculation as this Excel =PERCENTRANK() function.
Its full components in Excel are:
=PERCENTRANK(Array,X,[significance])
An example Array could be - 13,17,27,33,42,56,61,69,74,83,95,98
I am looking to find the percentage rank of each of the values in that array (x) - they are test scores.
The significance does not matter as much, as 4-6 decimal places would be handy to sort values that are close to each other out in a larger array.
What would be the equation for this function? I've tried to look up this function but cannot find the maths behind it or how to apply it within a SIMS assessment manager sheet.
Thank you in advance for your help!
