Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I creat a table of medians based on a second field?
I have two columns of data and I would like to create a table of medians for
column 2 based on the entries in column 1. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I creat a table of medians based on a second field?
Hawaiiantom -
Maybe someone can read your mind better than I can, but, if not, you may need to explain more about (1) what kind of data is in column 1, (2) what kind of data is in column 2, (3) what you mean by "table of medians," i.e, what you want as an end result, (4) specifically what you mean by "medians," i.e., whether you mean the measure of central tendency that can be calculated using Excel's MEDIAN worksheet function, and (5) how the values in column 1 are related to the values in column 2. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Hawaiiantom" wrote in message ... I have two columns of data and I would like to create a table of medians for column 2 based on the entries in column 1. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I creat a table of medians based on a second field?
I cannot claim to be more clairvoyant than Mike but here goes.
I read this as: In one column (let's say column A) you have some data; could be text or dates or anything but I will assume it is text In another column (we will say B) you have data but since you want a median value this must be numeric Let's say it looks like Jack 2 Mary 5 ..... Jack 6 Jill 3 ..... Jack 4 You want to know the median value associated with each person? Try =MEDIAN(IF(A1:A100="jack",B1:B1000)) but enter it as an array formula with SHIFT+CTRL+ENTER Also have a look at Pivot Tables http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm http://www.techonthenet.com/excel/pivottbls/index.htm http://www.dicks-blog.com/archives/2...le-parameters/ best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Hawaiiantom" wrote in message ... I have two columns of data and I would like to create a table of medians for column 2 based on the entries in column 1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creat table list | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Pivot table help:calculated field based on previous consecutive va | Excel Discussion (Misc queries) | |||
Pivot Table: Need Medians instead of means | Excel Discussion (Misc queries) |