How to get Median value from a data set

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

Guest

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.
 
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.
Click to expand...

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
 
Mike Labosh said:
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?
Click to expand...

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
 
Back
Top