Arte SheetsLearn. Try. Understand.

Statistical Analysis

Nelson-Aalen Cumulative Hazard H(t), Aalen Variance & Fleming-Harrington Survival

Estimate nonparametric cumulative failure hazard H(t) = SUM(d_i / n_i), Aalen standard error SQRT(SUM(d_i / n_i^2)), and exponential survival S_FH(t) = EXP(-H(t)) on right-censored cohorts.

Why Nelson-Aalen avoids zero-survival collapse at the final event time

When the last remaining subject at risk fails (d_k = n_k), the Kaplan-Meier product-limit estimator multiplies by (1 - d_k / n_k) = 0 and collapses estimated survival strictly to 0%. By contrast, Wayne Nelson (1972) and Odd Aalen (1978) accumulated discrete hazard increments directly: H(t) = SUM_{t_i <= t} (d_i / n_i), with martingale variance estimator Var(H(t)) = SUM_{t_i <= t} (d_i / n_i^2).

Exponentiating negative cumulative hazard yields the Fleming-Harrington (Breslow) survival estimator S_FH(t) = EXP(-H(t)), which stays strictly positive even when d_k = n_k and exhibits smaller small-sample bias in competing-risks and reliability engineering.

Month t_iAt Risk n_iEvents d_iHazard Step d_i/n_i & Cum H(t)
32020.1000 | H(3) = 0.1000
61620.1250 | H(6) = 0.2250
91020.2000 | H(9) = 0.4250
12820.2500 | H(12) = 0.6750 -> S_FH = 0.5092

Nelson-Aalen Hazard Increment & Cumulative H(t) Formula

Divide events C2 by risk-set size B2 per interval and accumulate SUM($D$2:D2) down the table.

=IF(B2 <= 0, 0, C2 / B2)

Aalen Standard Error & Fleming-Harrington Survival Formula

Sum C_i / (B_i ^ 2) for Aalen variance, take SQRT for SE(H), and evaluate ROUND(EXP(-H_t), 4) for survival probability.

=ROUND(EXP(-SUM(D2:D5)), 4)

Try the example

Use the original values or change them to test your understanding.

Further reading