Median & Mode

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

Guest

Does Access have an aggregate function for Median and Mode like it does for
Average? If not, is there a SIMPLE way to calculate the Median and Mode in a
report? Thanks.
 
As far as I know, Access does not have a "native" function for these two
measures of central tendency. But if you use a code module and References,
you should be able to reference these functions from the Excel library.

If this doesn't work, a generic description (?p-code?!) of Median is --
"line 'em up in order, take the one in the middle (or average, if there are
an even number"). The Mode is "that value which happens most frequently" --
note that a set of numbers could have more than one Mode.

Good luck!

Jeff Boyce
<Access MVP>, and former stats instructor
 
Back
Top