Can you calculate percentile/ quartiles in access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for a way to calculate the top 20%/ 50%/ 75% of my data in
Access. I know that you can do this in Microsoft Excel, but my data file is
too large to just run it in Excel. Is there a way to do this analysis in
Access?
 
Caroline said:
I'm looking for a way to calculate the top 20%/ 50%/ 75% of my data in
Access. I know that you can do this in Microsoft Excel, but my data file is
too large to just run it in Excel. Is there a way to do this analysis in
Access?
Click to expand...

You have to write a function to do this in Access. A neat solution is
presented here:

http://www.mvps.org/access/queries/qry0019.htm

HTH
Matthias Kläy
 
Back
Top