I am trying to create a 4 quadrant matrix similar to the one in the screenshot below. If you could please help with a solution that would be much appreciated
Can you give us more details? What does your input data look like? Is it supposed to act like a Magic Quadrant?
Dan
Hi, no not a magic quadrant. Its to show predicted vs actual. for example the first quadrant. 5 were forecasted y and 5 resulted in actual y. Quadrant 2, 1 was forecasted y and resulted in actual of n.
YY | YN | NN |
1 | 0 | 0 |
1 | 0 | 0 |
1 | 0 | 0 |
1 | 0 | 0 |
1 | 0 | 0 |
0 | 1 | 0 |
Thanks
Is YN different from NY, i.e. Cell 2,1 is different from cell 1,2
Dan
it is, sorry I forgot to include that combination. YN is forecasted Y actual N and NY is forecasted N actual Y
Here you go
Sum all the columns and transpose. Add the row and column names, crosstab and sort...because the Crosstab tool has it's own ideas about column and row order. Rename the columns to Y/N and use a space as the first column name to make it appear blank.
Dan