Preview. This page currently shows the analysis skeleton. The full worked walkthrough — sample dataset, connected steps, runnable code, interpretation — is being built.

HR / People Analytics · how-to

Flight Risk — predict which employees will resign — in Google Sheets

A turnover-prediction analysis. Every step below is the same analysis rendered for Google Sheets — grounded in the source, honest where Google Sheets can't do a step cleanly.

Same analysis, your tool

DERIVE

logistic regression needs numeric inputs; encode categoricals

=formula   // "derived", fill down

CORRELATE

screen which variables actually track turnover before modeling

=CORREL(driver_j, outcome)

FIT-CLASSIFIER

estimate the equation linking predictors to probability of resigning

Google Sheets can’t do this cleanly

FIT-CLASSIFIER has no clean sheets form —

VALIDITY · mechanical

confirm each predictor contributes reliably

=CORREL(measure, criterion)

PREDICT

score each employee's likelihood of leaving to prioritize retention

= const + b1*x1 + …   (fill down)

Honest note: Google Sheets can’t do 1 of these steps cleanly — the switcher shows which tools can.

Grounded in

Predictive HR Analytics with Excel, Sec 19.8 Logistic Regression: Predict Staff Resignation (also 12.4, 17.9)

Doing HR / People Analytics work?

The full HR / People Analytics guide covers this and the whole workflow around it — reconciled from the field’s best books.

Want to run it, not read it?

Run this analysis live on your data, in Google Sheets or any tool — powered by the Stepcode engine.