Re: Statistics problem
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Sun, 22 Jun 2008 00:03:56 -0400
On Sat, 21 Jun 2008 20:54:01 -0700, Brian Mc in StL <Brian Mc in
StL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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?
More data would be useful to try to figure out your problem, and why your Excel
is "locking up" (whatever that means)
=MIN(A:A)
=AVERAGE(A:A)
=MODE(A:A)
works fine with values in column A.
etc.
--ron
.
- References:
- Statistics problem
- From: Brian Mc in StL
- Statistics problem
- Prev by Date: Help with XDATE function add-in
- Next by Date: Re: Print data filled rows only
- Previous by thread: Statistics problem
- Next by thread: Re: Statistics problem
- Index(es):
Relevant Pages
|
