hello everyone....
I am performing contingency reports across a number of categorical X's towards a given Y (categorical) - where I like to highlight contingency table cells (from output report) based on conditions :
e.g. highlight if
count >=12
Cell Chi Square >=3.0
Would like to highlight the cell w/ some color (font color can also work, highlight is better) if it satisfies the given condition
Additional request: Is there a way to either sort the rows based on eg. decreasing Cell Chi Square -- however as the rows contain multiple row elements (in my setup, I use 3 : Count, Row % and Cell Chi Square) they would all need to be part of the sorting
OR
Is there a way to filter only rows that satisfy a given condition ? (ie these can be the highlighted ones)
Here is a sample script targeting your sample data (Aircraft Incidents.jmp)
Contingency(
Y( :Fatal ),
X( :Model ),
Contingency Table(
Count( 1, Format( "Fixed Dec", 8, 0 ) ),
Total %( 0, Format( "Fixed Dec", 8, 2 ) ),
Col %( 0, Format( "Fixed Dec", 8, 2 ) ),
Row %( 1, Format( "Fixed Dec", 8, 2 ) ),
Expected( 0, Format( "Best", 8 ) ),
Deviation( 0, Format( "Best", 8 ) ),
Cell Chi Square( 1, Format( "Fixed Dec", 8, 4 ) ),
Col Cum( 0, Format( "Fixed Dec", 8, 0 ) ),
Col Cum %( 0, Format( "Fixed Dec", 8, 2 ) ),
Row Cum( 0, Format( "Fixed Dec", 8, 0 ) ),
Row Cum %( 0, Format( "Fixed Dec", 8, 2 ) )
)
);
thx
Altug Bayram
