Posted to microsoft.public.excel.worksheet.functions

Brian Mc in StL Brian Mc in StL is offline

external usenet poster

Posts: 1

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Statistics - p value	psipg	Excel Worksheet Functions	3	June 14th 08 12:21 PM
Statistics	Mike H.	Excel Discussion (Misc queries)	4	October 25th 07 12:28 PM
Need statistics help!	Pizza	Excel Worksheet Functions	5	January 10th 07 10:05 PM
statistics problem	driller	New Users to Excel	1	November 18th 06 04:55 PM
p-value, statistics	wim rademakers	Excel Discussion (Misc queries)	1	January 18th 06 02:23 AM

All times are GMT +1. The time now is 03:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us