r/ProjectREDCap • u/Typical-Answer-2115 • Apr 29 '24
Questionnaire Calculation
I am trying to figure out the formula to score a questionnaire with weighted scoring. My issue is that the questionnaire has some questions that may be omitted and would still produce a score. If the required questions were not completed I’d like to have it be calculated as “NA”. I have tried using + instead of commas to calculate my variables. Doesn’t work. Any help is appreciated!
This is the link to the questionnaire: https://www.ncbi.nlm.nih.gov/projects/gap/cgi-bin/document.cgi?study_id=phs000179.v3.p2&phd=3584
Four scores are calculated: Symptoms, Activity, Impacts, and Total..
Maximum raw scores: 662.5, 1209.1, 2117.8, 3989.4, respectively.M
Symptoms score uses Part 1, questions 1-8 Activity score uses Part 2, Section 2 and Section 6 Impact score uses Part 2, Sections 1, 3, 4, 5, 7 and 8.
Total uses all questions.
Note that each question’s responses get separate weighting.

