Statistics Quest

Applied case · Banking · about 75 minutes

Default rates in a loan book

Estimate default rates with honest intervals, compare segments, fit a logistic regression and interpret odds ratios — and keep risk prediction separate from causal claims.

The brief

Wahat Lending (a fictional consumer-finance company) approved 3,000 personal loans in 2023 and tracked each one for 24 months. 12.9% defaulted (90+ days past due). The credit committee is reviewing its approval policy and has asked the risk analytics team for:

  1. the book's default rate with a confidence interval, and default rates by credit-score band and loan purpose;
  2. a simple model of default risk that the committee can read (which factors matter, and how much);
  3. a view on a proposed rule: decline every applicant with a credit score below 620.

The committee will also ask whether lending for business purposes is “riskier because of what the money is used for” — be careful with causal language.

The data. loans has one row per approved loan: purpose, verified monthly income, years with the current employer, credit score (300–850), debt-to-income ratio (%), amount, term, interest rate and a 0/1 default flag. It is synthetic, generated from a documented risk model; it describes no real lender or borrower.

Stakeholders. The credit committee (sets policy), the sales team (worried about turning away good customers), and, in this scenario, a regulator that expects lending decisions to be explainable and checked for unfair impact on protected groups.

Fairness. The file contains no protected characteristics (such as sex, age band or nationality), so this case cannot tell you whether a cut-off or a model treats groups differently. Variables like credit score, income or loan purpose can act as proxies for such characteristics; a real fairness review needs that data, an agreed definition of fairness and legal/compliance input.

Dataset

Personal loan applications

3,000 rows · one row = one approved loan · synthetic data

LoanApplication datePurposeMonthly income (SAR)Employment length (years)Credit score (points)Debt-to-income (%)Loan amount (SAR)Term (months)Interest rate (%)Defaulted
L000012023-10-28debt_consolidation97901.254835.6540003610.660
L000022023-07-08education890021.564627.630000367.770
L000032023-04-05car70800.661926.9990006010.090
L000042023-04-06debt_consolidation2019015.466423.951000126.710
L000052023-10-13home_improvement87204.4651378000369.620
L000062023-05-16business64102.556647.5240006010.871

Included with a Formula Quest membership

This case has 4 stages and 10 graded tasks, ending with a written report.

View Formula Quest memberships