How useful/useless is this mapping of
2nd level loan criteria?
What is that you ask...I've mapped what I think are the more practical criteria against all others (2nd level) and then sorted (descending) by default rate (and then population - higher population means more significant). Limited to a population of 10, just to get rid of the chaff.
It takes a little bit to generate, but I should be able to run it for individual grades and either report it or dump it out to csv. However, population numbers might be too low at the grade level, even with this data set (>20,000)...
I've not spent a lot of time going through it, but it contains some key info - I think?
Added: Just to explain the
first row in case it's not obvious:
This is taking all loans with a 'Residential Status' of 'Fully Owned - No Mortgage' AND a 'Loan Purpose' of 'Debt Consolidation' and calculating the number of defaults, the total number of loans and the default rate. In this case there are 118 loans that fit these two critera, none of which have defaulted.
This is the top of the chart, which is a fairly obvious set of criteria to take that lead place...