Median / reference to Excel in query?

  • Thread starter Thread starter Sheryl Bradley
  • Start date Start date
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!)
 
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)
 
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.
 
Back
Top