How to get Median value from a data set

[Mike]

All - I am trying to get Median value for my data set. My table has 3
fields, FromState, ToState, and PerMileRate. What I want is the Median value
of all rates that I have from one state to another state. For example, if I
have rate from GA to DE of $1.00, $1.40, $1.60, and $2.00, I want to get
Median value of $1.50.

 

[Mike Labosh]

All - I am trying to get Median value for my data set. My table has 3

fields, FromState, ToState, and PerMileRate. What I want is the Median
value
of all rates that I have from one state to another state. For example, if
I
have rate from GA to DE of $1.00, $1.40, $1.60, and $2.00, I want to get
Median value of $1.50.

Access has a built in function that does that (or at least it used to). Be
careful though -- there is an Avg() function that calculates the average of
a set, but that's not the same thing as a Median.

There IS a simple solution, I just can't remember the name of the function.
Somebody help?
--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

 

[Douglas J. Steele]

Access has a built in function that does that (or at least it used to).
Be careful though -- there is an Avg() function that calculates the
average of a set, but that's not the same thing as a Median.

There IS a simple solution, I just can't remember the name of the
function. Somebody help?

AFAIK, there's no Median function in Access. However, I did write about how
to calculate medians in my October, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free from http://www.accessmvp.com/djsteele/SmartAccess.html