Healthcare & Clinical Calculators
PIM3 and Standardised Mortality Ratios: A Spreadsheet Illustration
Use a fictional data set to understand observed-to-expected ratios in paediatric intensive-care reporting.
What PIM3 and the ratio measure
The Paediatric Index of Mortality 3 (PIM3) is a published statistical model used in risk-adjusted comparisons of paediatric intensive-care outcomes. Registry reports compare the observed number of deaths with an expected total based on an appropriately specified and calibrated model.
This worksheet does not calculate PIM3 or predict outcomes for a child. The five input probabilities below are invented solely to demonstrate arithmetic, not derived from patient data or the published model. Such ratios require expert interpretation, especially with small samples, and cannot by themselves establish the quality of care.
A fictional group example
Use five made-up probabilities, expressed as decimals from 0 to 1: 0.05, 0.10, 0.20, 0.15 and 0.30. Their sum is 0.80 expected events. If the fictional observed count is 1, the observed-to-expected ratio is 1 / 0.80 = 1.25.
This tiny example illustrates division only; 1.25 is not evidence of an excess risk, a clinical prediction, or a judgement of any unit. Real comparisons depend on an appropriate model, calibration, case selection, time period and statistical uncertainty.
| Fictional quantity | Value |
|---|---|
| Sum of five probabilities | 0.80 |
| Observed events | 1 |
| Observed / expected | 1.25 |
Sum the hypothetical probabilities
Enter five numeric probabilities in B2:B6 and a whole-number observed count in B7 between 0 and 5. The input check cannot validate an actual model or data set.
=IF(COUNT(B2:B7)<>6,"Enter five probabilities and an observed count",IF(OR(MIN(B2:B6)<0,MAX(B2:B6)>1,B7<0,B7>5,B7<>INT(B7)),"Invalid illustrative inputs",ROUND(SUM(B2:B6),4)))Divide observed by expected
The ratio is undefined when the expected total equals zero. Keep full-precision probabilities when working with a real statistical analysis rather than prematurely rounding individual estimates.
=IF(COUNT(B2:B7)<>6,"Enter five probabilities and an observed count",IF(OR(MIN(B2:B6)<0,MAX(B2:B6)>1,B7<0,B7>5,B7<>INT(B7)),"Invalid illustrative inputs",IF(SUM(B2:B6)=0,"Ratio undefined when expected total is zero",ROUND(B7/SUM(B2:B6),2))))Try the example
Use the original values or change them to test your understanding.