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 flag | Value |
|---|---|
| A | 1 |
| B | 0 |
| C | 0 |
| D | 1 |
| E | 0 |
| F | 0 |
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.