Anyone know of an easy way (any way) to calculate percentiles in ColdFusion?
I've a plethora of stats ... from members with easy reach via a MySQL database tables.
I'm looking to perform percentile calculations and cannot see a built-in function in CF or MySQL.
for example; ...
I can determine the income level of each and every one of my members.
I'd like to tell a SPECIFIC member which income percentile he fits ... in his specific region of the country (and/or world.
I'm a total CF newbie ... but slowly but surely these tidbits help!