Link to home
Start Free TrialLog in
Avatar of tmagesh
tmagesh

asked on

Percentile 99 and Percentile 01

How do I calculate the Percentile 99 and Percentile 01 in the Access Database? I see that we have the PERCENTILE worksheet function, but it takes an array of a maximum of 8191 data points. My need is to calculate the P99 and P01 for more than 60000 data points.
Avatar of HaydnH
HaydnH
You can list the top N % using the TOP predicate in SQL... So to calculate the top 1% you would use:

  SELECT TOP 1 PERCENT ScoreField FROM MyTable ORDER BY Score;

And to list the bottom 1% you would use:

  SELECT TOP 1 PERCENT ScoreField FROM MyTable ORDER BY Score DESC;


Haydn.
ASKER CERTIFIED SOLUTION
Avatar of HaydnH
HaydnH
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of stevbe
stevbe
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: HaydnH {http:#9657806}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

stevbe
EE Cleanup Volunteer