Arte SheetsLearn. Try. Understand.

Statistical & Clinical Analysis

PRISM III Research and Summarizing Numbers in a Spreadsheet

Review the original pediatric intensive-care research and practice a separate example of mean and maximum calculations.

About the original PRISM III study

Pollack, Patel and Ruttimann published the PRISM III pediatric mortality-risk model in 1996. The study used 17 physiological variables with defined ranges and evaluated model performance in pediatric intensive-care settings. Its interpretation requires the complete model, appropriate data and validation for the population and purpose.

This worksheet does not calculate PRISM III, estimate an individual outcome or prescribe monitoring. It uses unrelated fictional numbers to show how summary statistics work. Clinical assessment and care decisions belong to the treating professionals.

A fictional data summary

For the four invented values 10, 7, 3 and 4, the mean is (10 + 7 + 3 + 4)/4 = 6 and the maximum is 10. These numbers are not PRISM III subscores or patient observations. A mean and maximum do not describe a population’s full distribution or clinical risk.

QuantityValue
Fictional observations10, 7, 3, 4
Mean6
Maximum10

Calculate the mean

Enter four numeric values in B2:B5. COUNT requires all four entries to be numeric before AVERAGE is calculated.

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

Find the maximum

The same completeness check prevents MAX from silently returning a result when a value is missing.

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

Try the example

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

Further reading