Calculating Median and Mode

  • Thread starter Thread starter marilyn.foley
  • Start date Start date
M

marilyn.foley

I've been unsuccessful finding the median & mode
functions in Access. They are available in Excel, but
it's not possible to use Excel when the number of records
exceeds 60,000. Does anyone know how to calculate these
basic statitical functions in Access?
 
Would you happen to be working on a Standard Error
formula as well?
-----Original Message-----
The median function is calaculated using the following
Click to expand...
formula. "=SUM(B1:B20)/COUNT(B1:B20)" where B1:B20 is the
cell range.You could then just use this formula to
calculate the Median in Access.
 
Back
Top