Healthcare & Clinical Calculations
Dermatology Life Quality Index: Ten-Item Score Arithmetic
Explore the arithmetic of ten fictional DLQI item scores, the official missing-response guidance, and the limitations of using a score alone.
Understanding the ten-item score
The Dermatology Life Quality Index (DLQI), developed by Finlay and Khan, asks about the effect of a skin condition on quality of life over the preceding week. Ten items are scored from 0 to 3, with a total from 0 to 30. Published interpretation bands describe increasing impact, but a total cannot capture every aspect of a person’s experience.
A DLQI above 10 does not by itself establish eligibility for a biological treatment. For example, NICE guidance for particular psoriasis medicines includes additional severity, treatment-history and individual circumstances. Decisions depend on the complete assessment and the relevant guidance.
| Total score | Published impact description |
|---|---|
| 0–1 | No effect on quality of life |
| 2–5 | Small effect |
| 6–10 | Moderate effect |
| 11–20 | Very large effect |
| 21–30 | Extremely large effect |
Add ten complete, already-scored values
This teaching example accepts ten fictional, pre-scored integers from 0 to 3 and returns their sum. It is an arithmetic exercise, not a questionnaire or treatment-eligibility tool.
Cardiff University’s official instructions allow one unanswered question to be scored as zero; with two or more unanswered, the questionnaire is not scored. This complete-response example instead requires all ten numeric entries and does not implement the official missing-data rule. Consult Cardiff’s full instructions when administering or interpreting the instrument.
=IF(COUNT(B2:B11)<>10,"Enter all ten numeric scores for this example",IF(OR(MIN(B2:B11)<0,MAX(B2:B11)>3,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0,MOD(B8,1)<>0,MOD(B9,1)<>0,MOD(B10,1)<>0,MOD(B11,1)<>0),"Each score must be an integer from 0 to 3",SUM(B2:B11)))Try the example
Use the original values or change them to test your understanding.