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.
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 = 1moderately disagree = 2slightly disagree = 3slightly agree = 4moderately agree = 5 strongly agree = 6GRIDSCORE(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 = 6moderately disagree = 5slightly disagree = 4slightly agree = 3moderately agree = 2 strongly agree = 1GRIDSCORE(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)) / 29Note: Type @ and select the required multiple choice grid question from the list to add its entry #id in the above formula.
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to calculate score.
Try It Free