How to assign different points for specific statements in a multiple choice grid question?

You can use the GRIDSCORE function to assign points for the answer choices in the multiple choice grid question and calculate the score. GRIDSCORE function should be used if one or more statements in the multiple choice grid question have different points.

How to assign points using the GRIDSCORE function?

Let's create the Oxford Happiness Questionnaire to measure the current level of happiness. This happiness questionnaire consists of 29 statements. The items are a combination of positively and negatively phrased statements and pertain to different areas of well-being. This ensures that the respondent takes time to carefully read each item before answering. The survey asks you to evaluate each statement and rate it according to how much you disagree or agree with the statement. It uses a 6-point Likert scale with 6 being the highest as “strongly agree”.

We will use a multiple choice grid question with 29 statements that pertain to different areas of well-being. The answer choices for this multiple choice grid question is as follows: strongly disagree, moderately disagree, disagree, agree, moderately agree, strongly agree. Please follow the instructions below to assign points and calculate the score.

GRIDSCORE function

You can use the GRIDSCORE function to assign the points to the columns (answer choices) for specific rows (statements) in a grid question and calculate the score.

The happiness questionnaire has 29 statements in a multiple choice grid question with a 6-point likert scale. Twelve of the 29 items are scored reversely. The answer choices for statements 2, 3, 4, 7, 8, 9, 11, 12, 15, 16, 17, 18, 20, 21, 22, 25, 26 will be assigned the points as shown below.

strongly disagree = 1
moderately disagree = 2
slightly disagree = 3
slightly agree = 4
moderately agree = 5
strongly agree = 6

GRIDSCORE(entry#id, [2, 3, 4, 7, 8, 9, 11, 12, 15, 16, 17, 18, 20, 21, 22, 25, 26], 1, 2, 3, 4, 5, 6)

The answer choices for statements 1, 5, 6, 10, 13, 14, 19, 23, 24, 27, 28, 29 will be assigned the points as shown below.

strongly disagree = 6
moderately disagree = 5
slightly disagree = 4
slightly agree = 3
moderately agree = 2
strongly agree = 1

GRIDSCORE(entry#id, [1, 5, 6, 10, 13, 14, 19, 23, 24, 27, 28, 29], 6, 5, 4, 3, 2, 1)

Happiness score is the average of all the statements. The formula to calculate the happiness score is:
(GRIDSCORE(entry#id, [2, 3, 4, 7, 8, 9, 11, 12, 15, 16, 17, 18, 20, 21, 22, 25, 26], 1, 2, 3, 4, 5, 6) + GRIDSCORE(entry#id, [1, 5, 6, 10, 13, 14, 19, 23, 24, 27, 28, 29], 6, 5, 4, 3, 2, 1)) / 29

Note: Type @ and select the required multiple choice grid question from the list to add its entry #id in the above formula.