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 cumulative(0, Format("Fixed Dec", 8, 0)),
Col cumulative %(0, Format("Fixed Dec", 8, 2)),
Row cumulative(0, Format("Fixed Dec", 8, 0)),
Row cumulative %(0, Format("Fixed Dec", 8, 2))
)
);
thx
Altug Bayram