Posted to microsoft.public.excel.misc

Lisab

external usenet poster

Posts: 30

How can I find a median?

Hello,

I want to find a median for team size with data that is currently set up in
the following manner:

Team size # of instances
20 3
9 1
8 2

Is there an easy way to convert the information so that I can use the median
function?
Thanks.
I n

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
median if	Irv1010	Excel Worksheet Functions	4	November 19th 09 04:01 PM
find for non zero values in a column Median,Mode,STDEV	Billp	Excel Worksheet Functions	2	June 24th 09 03:20 PM
Find the median 3 values	Horatio J. Bilge, Jr.	Excel Discussion (Misc queries)	6	November 20th 07 07:13 PM
Median	reno	Excel Discussion (Misc queries)	3	August 21st 07 08:12 PM
Find Median of Positive numbers only in Range	MichaelC	Excel Worksheet Functions	4	June 24th 05 03:06 AM

All times are GMT +1. The time now is 08:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us