Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculators

The Logistic Link in EuroSCORE II: An Educational Example

Explore a logistic transformation using invented values; this worksheet is not a cardiac-surgery risk calculator.

What the published model does

EuroSCORE II is a logistic model published in 2012 to estimate in-hospital mortality after adult cardiac surgery. It combines specifically defined patient and procedure variables with published coefficients. Reproducing it requires the complete model and its exact variable definitions.

The worksheet below illustrates the mathematical link only. Every input is invented, the values are not EuroSCORE II coefficients, and the result does not describe a patient or a surgical outcome. Use the original publication and appropriate professional interpretation when studying the clinical model.

A fictional logistic transformation

Add the invented intercept −3 and contributions 0.5, −0.2 and 0.7 to get a linear predictor z = −2. The logistic function 100/(1 + EXP(−z)) gives 11.92 on a 0–100 scale. This number is only the output of a mathematical example, not a mortality estimate.

Contributions can be positive or negative. The worksheet checks that all four inputs are numeric; it cannot verify any underlying model.

Fictional linear predictor zLogistic output on a 0–100 scale
−211.92
050.00
288.08

Add the illustrative model values

Place the fictional intercept and three signed contributions in B2:B5. All four cells must contain numeric values.

=IF(COUNT(B2:B5)<>4,"Enter four numeric model values",ROUND(SUM(B2:B5),4))

Apply the logistic link

The equivalent expression uses EXP(−ABS(z)) to avoid overflowing EXP for large positive or negative z. The rounded result is a mathematical transformation, not a validated estimate.

=IF(COUNT(B2:B5)<>4,"Enter four numeric model values",LET(z,SUM(B2:B5),e,EXP(-ABS(z)),ROUND(IF(z<0,100*e/(1+e),100/(1+e)),2)))

Try the example

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

Further reading