Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculators

PELOD-2 Research and the Logistic Function: A Spreadsheet Example

Explore a fictional logistic transformation and read the original PELOD-2 pediatric intensive-care research.

PELOD-2 and its research setting

The Pediatric Logistic Organ Dysfunction-2 (PELOD-2) score was developed in a pediatric intensive-care research setting to describe organ dysfunction. Its published model uses specifically defined clinical observations; score assignments, timing and interpretation must follow the original definitions and applicable local context.

The worksheet below is a separate mathematical example. It does not calculate PELOD-2, assign organ-system points, predict mortality for a child, or replace clinical assessment. A model estimate is not a certain outcome, and performance can vary across populations and settings.

A fictional logistic transformation

For a fictional linear predictor z, the logistic function is 1/(1 + EXP(−z)). With z = −1.5 the result is approximately 0.1824; at z = 0 it is 0.5; at z = 1.5 it is 0.8176. These numbers are invented for mathematics and are not PELOD-2 patient predictions.

The formula below uses EXP(−ABS(z)) in an equivalent form so large positive and negative values do not require EXP of a large positive number. The result is rounded to four decimal places.

Invented linear predictorLogistic output
−1.50.1824
00.5000
1.50.8176

Evaluate the logistic function

Enter one numeric example value in B2. The numeric check does not validate a statistical model or clinical data.

=IF(COUNT(B2)<>1,"Enter a numeric example value",LET(z,B2,e,EXP(-ABS(z)),ROUND(IF(z<0,e/(1+e),1/(1+e)),4)))

Try the example

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

Further reading