← All projects
Supporting case study · Forecasting & Finance

Retirement Investment Behavior Regression Analysis

Analyzed how salary, children, mortgage, and debt related to the percentage of income invested for retirement across 194 couples.

ExcelMultiple RegressionCorrelation AnalysisFinancial BehaviorData Storytelling
Retirement Investment Behavior Regression Analysis project graphic
194couples analyzed
0.45model R²
4predictors
Excelanalysis platform
The challenge

What needed to be understood.

Investment behavior reflected several competing household pressures. The analysis needed to separate salary effects from children, mortgage obligations, and debt.

Approach

How the analysis was built.

  1. Explored 194 household records using descriptive statistics and scatterplots.
  2. Calculated correlations between investing and each predictor.
  3. Built a multiple-regression model using salary, children, debt, and mortgage.
  4. Translated statistical results into audience-focused financial-education recommendations.
Key findings

What the evidence showed.

  • Salary showed a positive relationship with retirement investing.
  • Children and debt showed negative relationships of similar magnitude in the submitted analysis.
  • Mortgage also had a negative but weaker relationship.
  • The multiple-regression model explained about 45% of variation in the sample.
Business recommendations

What should happen next.

  • Target education and simplified contribution options toward lower-income and high-debt households.
  • Promote early, small, recurring contributions rather than all-or-nothing messaging.
  • Use additional variables such as age, employer match, and financial literacy in future models.
Limitations and integrity

What this project does—and does not—prove.

The analysis identified association, not causation, and the sample contained 194 couples rather than a representative population.

Continue exploring

More projects, methods, and business questions.