Statistics Quest

Personal loan applications

3 000 approved personal-loan applications from 2023 at a fictional consumer-finance company, Wahat Lending, with each borrower's outcome after 24 months. Columns include monthly income, credit score (300–850), debt-to-income ratio, employment length, purpose, amount, term, interest rate and whether the loan defaulted. Built for default-rate tables, logistic regression and evaluating a classifier (confusion matrix, ROC, calibration).

Rows
3,000
Columns
11
One row is
one approved loan
Version
v1

Data dictionary

ColumnTypeUnitSummaryDescription
loan_id
Loan
idLoan identifier.
application_date
Application date
dateDate the application was approved (2023).
purpose
Purpose
category6 levels: debt_consolidation, home_improvement, car, education, business, personalStated purpose of the loan.
monthly_income_sar
Monthly income
numberSARmean 15120, median 13240, SD 8277, range 4000–78040Verified gross monthly income.
employment_years
Employment length
numberyearsmean 5.434, median 4.4, SD 4.22, range 0–30.4; 61 missingYears with current employer.Missing: Null for 61 self-employed applicants (no employer tenure recorded).
credit_score
Credit score
integerpointsmean 688.1, median 688, SD 64.05, range 464–850Bureau-style credit score at application (300–850, higher = lower risk).
debt_to_income_pct
Debt-to-income
number%mean 30.81, median 30.8, SD 9.692, range 2–62.9Existing monthly debt payments as a percentage of monthly income.
loan_amount_sar
Loan amount
numberSARmean 93980, median 72000, SD 72990, range 5000–400,000Amount borrowed.
term_months
Term
integermonthsmean 36.84, median 36, SD 15.17, range 12–60Repayment term.
interest_rate_pct
Interest rate
number%mean 7.571, median 7.565, SD 1.632, range 3.5–12.64Annual interest rate (APR).
defaulted
Defaulted
integermean 0.1293, median 0, SD 0.3356, range 0–11 if the loan defaulted (90+ days past due) within 24 months, else 0.

What it is good for

  • Tabulate default rates by credit-score band and purpose.
  • Fit and interpret a logistic regression (odds ratios) for default.
  • Evaluate a classifier with a confusion matrix, sensitivity/specificity, ROC/AUC at different thresholds.
  • Discuss why only approved loans appear (selection) and what that means for conclusions.

Methods: contingency tables, logistic regression, odds ratios, ROC curve, AUC, confusion matrix, calibration.

Data quality notes

  • Overall default rate is about 13% — an imbalanced outcome.
  • employment_years is missing for 61 self-employed applicants. In this simulation they were chosen at random, so the missingness is unrelated to the other variables (MCAR) — real data are rarely that kind.
  • Credit score, DTI and interest rate are correlated (the rate is priced from the score).
  • Only approved applications are included, so the data cannot show how rejected applicants would have performed.

Provenance and licence

Monthly income is log-normal (median ≈13 500 SAR). Credit score is normal (mean ≈690, sd 65) shifted slightly by income, clamped to 300–850. Debt-to-income falls with credit score. Loan amount ≈ income × gamma-distributed multiple, rounded to 1 000 SAR; term is more often 60 months for larger loans; the interest rate is priced from the credit score. Default (0/1) is Bernoulli with a logistic model in credit score, DTI, 60-month term, employment years, business purpose and loan-to-income (coefficients exported as LOANS_TRUE_MODEL). Employment years are then blanked for 61 self-employed applicants.

Synthetic data · CC0-1.0 (synthetic data generated by Statistics Quest) · generated deterministically (seed 20241010). It does not describe real people or organisations; any resemblance is coincidental.

Preview

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
L000072023-11-15home_improvement200002.961237.4870006010.750
L000082023-10-31business154303.970034.7120000246.360
L000092023-09-29debt_consolidation118703.67703353000244.840
L000102023-07-11home_improvement102203.472310.584000366.970
L000112023-01-03business12610571230.568000485.920
L000122023-12-30debt_consolidation82101.770441.545000127.350

Used in