How can I get percentile value of a column of values in a calculated field?

[skyun]

Hi everyone,

I'm a new user to Microsoft Access and I am trying to make a query that has a calculated field that calculates the percentile value of some values in a table. I was wondering (besides VBA or any other coding) how I can get a percentile value in Access?

 

[jdraw]

see www.access-programmers.co.uk/forums/showthread.php?t=148926 for ideas

Also, there is a vba function to calculate Percentile here (calls Excel)
http://bytes.com/topic/access/answers/836797-percentile-calculation-access

 

[garycarnay02]

In addition to the percentile function, there is also a weighted percentile, where the percentage in the total weight is counted instead of the total number. There is no standard function for a weighted percentile. One method extends the above approach is a natural way.