topic Multiple Contingency Tables - How do I get the name of the filter category in Discussions

Multiple Contingency Tables - How do I get the name of the filter category

JensRiege — Sun, 15 Sep 2019 12:52:01 GMT

I am creating a report based on a very large set of Contingency tables created by using Fit Y by X, by factor Z. Example:

A Data Table has three columns X, Y, Z

When I select Analyze, Fit Y by X, By factor Z, I get all contigency tables, where each table is for each Z factor.

The only row in each contingency table I want is the row% so I deselected display of the other three rows before selecting Make into a Data Table after right clicking on the red arrow.

After turning off Mosic Plots and Tests, and leaving just the Contingency tables, I want to concatenate all of these tables into a single table with a column that lists the Z factor for each table. Since each Z factor does not appear to be stored with each Contingency Table, how to I capture this Z factor data to be assocated with each contingency table?

Re: Multiple Contingency Tables - How do I get the name of the filter category

JensRiege — Mon, 16 Sep 2019 12:13:24 GMT

This is some of the code I have so far, assuming that there are multiple contingency tables open:

Names Default To Here( 1 );
Clear Log();
// Create a list of all table names:
dtList = {};
For( i = 1, i <= N Table(), i++,
	dt = Data Table( i );
	Insert Into( dtList, dt );
);
Eval( dtList[1] ) << New Column( "added column", set each value( 5 ) );
Show( dtList );

// Trying to create a single table from all of the Open Contingency Tables
For( i = N Table(), i >= 0, i--,
	Concatenate( dtList[i], "Append to first table", "Create source column" )
);

Re: Multiple Contingency Tables - How do I get the name of the filter category

ron_horne — Sun, 15 Sep 2019 16:15:38 GMT

Hi @JensRiege

i would attempt using other platforms to produce the final table you are looking for.

the first thing that comes in mind is Analyze >> Tabulate.

second option: Table >> summary

i find these much more versatile and controllable.

please let us know if this helps at all.

ron

Re: Multiple Contingency Tables - How do I get the name of the filter category

JensRiege — Tue, 17 Sep 2019 15:10:12 GMT

Thank you Ron for your suggestion.

I am reviewing the documentation on the Tabulate Platform to see if I can get the same results that the Contingency Analysis provides in the Analyze Fit Y by X platform.

Re: Multiple Contingency Tables - How do I get the name of the filter category

ron_horne — Tue, 17 Sep 2019 20:01:09 GMT

Hi @JensRiege ,

Try to see the two scripts in the attached data table.

if you need any help from there let us know.

ron