topic Re: Median for all columns in Discussions

Median for all columns

vishwasanj — Mon, 17 Sep 2018 21:00:25 GMT

Hi All,

Is there an easier way to calculate median of all the columns, rather than getting the summary in different tables and then joining all the data tables together? I have like 200 columns that I need to calculate the median from. I appreciate all the comments and suggestions.

for(r=1,r<=N Items(List),r++,
Summary(
Group( :Mask, :Lot,:Workweek ),
Median( Column(dt,List[r]) ),
Freq( "None" ),
Weight( "None" )
);
 
);

Re: Median for all columns

dale_lehman — Mon, 17 Sep 2018 18:57:18 GMT

You can use the Table-Summary command. Choose all the columns (of course, nominal columns will not give you medians) and choose Median from the drop down. Do not put a grouping variable. You will get a new data table with all the median values.

Re: Median for all columns

vishwasanj — Mon, 17 Sep 2018 19:09:52 GMT

Hi Dale,

Thank you for the suggestion. I need to put the grouping variable by workweek, lot and mask. Is there a way to open a new data table and populate it median values sorted by the grouping variable for different columns?

Thanks.

Re: Median for all columns

dale_lehman — Mon, 17 Sep 2018 19:15:44 GMT

Use the Tabulate platofrm (under the Analyze menu). You should be able to put your grouping variables in any order you want and just ask for the median for all the continuous columns (put in the body of the table). Then Make into a Data Table (found at the red arrow in the Tabulate platform).

Re: Median for all columns

vishwasanj — Mon, 17 Sep 2018 21:01:26 GMT

Thats a really nice idea. Thanks Dale. If I have changing column names, I need to see how to represent the list of column names in "Analysis column" if I use a loop function. any thoughts?

(dt <<Tabulate(
Show Control Panel( 0 ),
Add Table(
Column Table(
Statistics( Median ),
Analysis Columns(
:Name( "ColA" ),
:Name( "ColB" ),
:Name( "ColC" ),
:Name( "ColD" ),
:Name( "ColE" )
)
),
Row Table( Grouping Columns( :LOTID, :MASK, :WW ) )
)
) )<< Make Into Data Table;

Re: Median for all columns

vishwasanj — Mon, 17 Sep 2018 20:15:16 GMT

Actually that works. Thank you Dale.