Health & Fitness
STOP-Bang Sleep Apnea Screening: An Overview and a Binary-Flag Exercise
Learn what STOP-Bang screening is designed to do and practice validating fictional yes/no flags without using this worksheet as a questionnaire.
What STOP-Bang screening can and cannot tell you
STOP-Bang is a screening questionnaire developed to identify people who may have obstructive sleep apnea (OSA), especially in perioperative and sleep-clinic settings. It combines questions about sleep symptoms with factors including blood pressure, body size and age. Published variants and clinical contexts may use different thresholds or follow-up rules.
A screening result does not by itself diagnose or exclude OSA, measure severity, or clear a patient for anesthesia. A clinician can assess symptoms and determine whether sleep testing is appropriate. The original research and official source are linked below.
The official STOP-Bang site asks users to seek permission to use its survey. This article does not provide a functioning version of the questionnaire; consult the original source and confirm any applicable permission before deploying it.
A separate exercise with four fictional flags
Enter a numeric 0 or 1 in each cell B2:B5. COUNT first requires all four values; COUNTIF then verifies that each is binary before SUM counts the positive flags. These fictional flags have no connection to medical questions or risk categories.
The example tests spreadsheet arithmetic only and is not a STOP-Bang score, a screening result, or a clinical device.
=IF(COUNT(B2:B5)<>4,"Complete all four numeric flags",IF(COUNTIF(B2:B5,0)+COUNTIF(B2:B5,1)<>4,"Use only 0 or 1",SUM(B2:B5)))Try the example
Use the original values or change them to test your understanding.