Arte SheetsLearn. Try. Understand.

Clinical Medicine & Physiology

SNAQ Appetite Score: A Four-Item Spreadsheet Example

Add four assessed appetite questionnaire scores and see why screening thresholds and study results need context.

SNAQ is a screening questionnaire, not a diagnosis

Wilson and colleagues developed the four-item Simplified Nutritional Appetite Questionnaire (SNAQ) from the longer CNAQ. It covers appetite, fullness, taste and meal frequency. Each item has a score from 1 to 5, giving a total of 4 to 20. Obtain and complete the original questionnaire before entering item scores; the worksheet below only demonstrates the arithmetic.

The original publication studied community-dwelling adults and long-term care residents and reported sensitivity of 81.3% and specificity of 76.4% for identifying 5% weight loss. These are group-level study findings, not a probability that a particular person will lose weight. Appetite changes and weight loss have many possible causes.

Sum four assessed item scores

Enter four independently assessed numeric item scores in B2:B5. The formula rejects blanks, text, fractions and numbers outside 1–5.

=IF(COUNT(B2:B5)<>4,"Enter four whole-number item scores from 1 to 5",IF(OR(MIN(B2:B5)<1,MAX(B2:B5)>5,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0),"Enter four whole-number item scores from 1 to 5",SUM(B2:B5)))

Illustrate one published threshold

Some studies and protocols use a total of 14 or less as a screening threshold, while others use below 14; these differ when the total is exactly 14. The formula illustrates the first convention only, not a universal cutoff. A screening result does not diagnose malnutrition or determine a treatment; the meaning depends on the population and assessment used.

=IF(COUNT(B2:B5)<>4,"Enter four whole-number item scores from 1 to 5",IF(OR(MIN(B2:B5)<1,MAX(B2:B5)>5,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0),"Enter four whole-number item scores from 1 to 5",IF(SUM(B2:B5)<=14,"At or below 14 on this example threshold","Above 14 on this example threshold")))

Example and interpretation

For assessed scores 3, 3, 4 and 3, the total is 13; it is at or below the example threshold of 14. This does not prove that weight loss will occur. The threshold does not establish an additional “severe” category at 12.

Try the example

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

Further reading