Healthcare & Clinical
Barthel Index: Validating Ten Daily-Activity Scores
Explore the arithmetic of a common 0–100 Barthel Index form, checking each fictional item score individually.
Ten activities and several scoring versions
The Barthel Index, introduced by Mahoney and Barthel, assesses basic activities of daily living and mobility. One common 0–100 form assigns scores in five-point steps, with maximum item scores of 5, 10 or 15. Other Barthel versions use different scales and item definitions; use the scoring instructions for the version being administered.
A higher total indicates more independence in the activities measured, but a score of 100 does not by itself establish that someone can live independently in the community. Discharge and support planning require a broader assessment.
| Items in the common 0–100 form | Allowed pre-scored values |
|---|---|
| Bathing and grooming | 0, 5 |
| Feeding, dressing, bowels, bladder, toilet use, stairs | 0, 5, 10 |
| Bed/chair transfer and mobility | 0, 5, 10, 15 |
Check every score before summing
Enter ten numeric pre-scored values according to the common form described above. The formula checks each individual value and its item-specific maximum, so two invalid values cannot cancel each other out to create an apparently valid total.
This is a fictional arithmetic example; it is not a functional assessment, a discharge recommendation or a substitute for the instrument’s criteria.
=IF(COUNT(B2:B11)<>10,"Enter all ten numeric scores",IF(OR(MIN(B2:B11)<0,B2>10,MAX(B3:B4)>5,MAX(B5:B8)>10,MAX(B9:B10)>15,B11>10,MOD(B2,5)<>0,MOD(B3,5)<>0,MOD(B4,5)<>0,MOD(B5,5)<>0,MOD(B6,5)<>0,MOD(B7,5)<>0,MOD(B8,5)<>0,MOD(B9,5)<>0,MOD(B10,5)<>0,MOD(B11,5)<>0),"Check each item against its allowed values",SUM(B2:B11)))Try the example
Use the original values or change them to test your understanding.