ROWS EXAMINED
240Recorded questionnaire rows01 / THE PROBLEM
The spreadsheet looked ordinary.
It wasn't.
At first glance, the study had two equally sized groups and hundreds of answers. Instead of immediately testing which group scored higher, I checked whether the underlying responses made sense.
DISTINCT ANSWER PATTERNS
86Many records repeated the same answersMATCHING CROSS-GROUP PAIRS
119/120Almost every aligned pair answered 76 items identicallyWhat this means: Different rows don't always mean independent answers. Spotting that distinction is part of the analysis—not a footnote.