inter-quartile range...possible in access?

[Emelina Bumsquash]

Hi all, does anyone know if it's possible to get Access to perform an
inter-quartile range (IQR) calculation in a query? i have a large amount of
data and would ideally like to use access to pull out certain stats. thanks
in advance for any help!

 

[Steve]

I don't know what an inter-quartile range (IQR) calculation is but
calculations in Access are generally done in a query.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Matthias Klaey]

Hi all, does anyone know if it's possible to get Access to perform an
inter-quartile range (IQR) calculation in a query? i have a large amount of
data and would ideally like to use access to pull out certain stats. thanks
in advance for any help!

You will find the function XPercentile at

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


In your query, you would then calculate

IQR: XPercentile("FName", "TName", 0.75) -
XPercentile("FName", "TName", 0.25)

where "TName" is the name of your table, and "FName" is the name of
the field that contains the data.

HTH
Matthias Kläy