Quote Originally Posted by myles View Post
Had wanted to work out how to create a 'Fence' chart (finicky to get right) so thought I'd give it a go for this. Result below:

Attachment 10054

Not sure if there is enough detail to be meaningful? Would running it for individual grades (i.e. A1, A2) be useful? Let me know what you think.

Perhaps there is a better way to show what you want - or it might be best to use a Pivot Table once you have the data and slice and dice as you want?
Despite not requesting this data , the result of grade vs enquiry is interesting.

Shows that grade is a far more important then # of enquiry in predicting a default. Hard to gleen much (as there may be confounders such the cohort mix), but it seems to suggest a 6+ defaults at A-C grade spikes default; D to E grades it doesn't seem to matter, and at F there appears to be an inverse relationship ie more enquiries results in less defaults. Fascinating!