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 predictor | Logistic output |
|---|---|
| −1.5 | 0.1824 |
| 0 | 0.5000 |
| 1.5 | 0.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.