Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

The PECARN Study and Binary Data: A Spreadsheet Exercise

Learn to validate and count fictional binary flags while reading about the PECARN head-injury research.

What the PECARN study investigated

The 2009 PECARN study developed and validated age-specific prediction rules for clinically important traumatic brain injury in children assessed after minor blunt head trauma. The study has different predictors for children under 2 and for children aged 2 and above; its intended setting and inclusion criteria matter.

This page does not implement the PECARN rules and cannot decide whether a child needs a CT scan or medical assessment. Head injuries should be assessed by qualified clinicians using appropriate guidance and the complete clinical context. The original study and current NICE guidance are linked below.

A separate binary-data example

The fictional flags below are abstract 0/1 spreadsheet values, not patient findings. Enter 1, 0, 0, 1, 0 and 0 to obtain a count of two. Checking that flags are present and binary is an elementary data-quality exercise; a sum does not determine a diagnosis or an imaging decision.

Fictional flagValue
A1
B0
C0
D1
E0
F0

Validate and count six flags

Enter six numeric values in B2:B7. COUNT rejects blanks and text; the second check accepts only the integers 0 and 1.

=IF(COUNT(B2:B7)<>6,"Enter six numeric flags",IF(SUMPRODUCT((B2:B7<>0)*(B2:B7<>1))>0,"Flags must be 0 or 1",SUM(B2:B7)))

Try the example

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

Further reading