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
Predict Employee Churn from Organizational Network — in Excel
A network-driver analysis. Every step below is the same analysis rendered for Excel — grounded in the source, honest where Excel can't do a step cleanly.
Same analysis, your tool
DERIVE
convert the network into quantitative signals per person
=formula ' new column "derived", fill downJOIN · mechanical
link network position to who stayed or left
=XLOOKUP(key, lookup_key, return_col) ' or Power Query ▸ MergeCORRELATE
identify which network signals predict staying
=CORREL(driver_j, outcome)FIT-CLASSIFIER
model resignation odds from connectedness and context
' logistic/classifier via Solver (maximize log-likelihood) or an add-in — no native fitPREDICT
flag well-connected people worth retaining
' apply the fitted equation per row: y = const + b1*x1 + …Grounded in
Predictive HR Analytics with Excel — §17.8/17.9 ONA graph metrics & churn
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 Excel or any tool — powered by the Stepcode engine.