Median / reference to Excel in query?

S

Sheryl Bradley

Posted earlier in the week looking for a way to get
the "Median" of a set of data as a field in a query. The
following was offered as a great suggestion.

I don't think there's any way to do this as part of the
query, but just thought I'd throw it out there and see if
anyone has a solution. (Too bad Access doesn't have a
Median function ... it's a common request!)
 
M

MGFoster

Sheryl said:
Posted earlier in the week looking for a way to get
the "Median" of a set of data as a field in a query. The
following was offered as a great suggestion.




I don't think there's any way to do this as part of the
query, but just thought I'd throw it out there and see if
anyone has a solution. (Too bad Access doesn't have a
Median function ... it's a common request!)
Click to expand...

Doesn't the SQL Avg() aggregate function work the same as the Excel
Median() function? Avg() returns the median average of a list of values
(Median = middle).

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
 
J

John Spencer (MVP)

The median is the middle value of a group of ordered items. For example the 13th
item in an ordered list of 25 items.

The mean is what most people call the average and what is calculated by the Avg
function in SQL. It is the sum of the items divided by the number of items.

The mode (a third type of average) is the most frequently occuring value.

I believe that if you "Google" the Access groups you should be able to find at
least one function that will get calculate the median for you.
 
Top