Statistics problem
I need to determine mean, median, mode, min, max and rank for a set of data
that exceeds a count of 255. Excel keeps locking up on me I think because
these functions are limited to arrays of 255 numbers or less.
Is there a way I can calculate these statistics on sets of data numbering in
the thousands?
|