Does anyone know if there is a built-in function for Access that is equivalent to the quartile function in excel?
If not, any ideas on how to recreate it?
I am thinking
quartile 0 = min
quartile 1 = sum of range * .25
quartile 2 = sum of range * .50
quartile 3 = sum of range * .75
quartile 4 = max