Computing avg. number options selected on multi-answer question | XM Community
Skip to main content
Michael_Cooksey
Administrator
1 month ago
Solved

Computing avg. number options selected on multi-answer question

L
Level 1 ●
Forum|alt.badge.img+1

I am working on a survey that makes use of questions that respondents can submit multiple answers to. Qualtrics will display the total counts of each answer choice but that’s not exactly what I’m looking for. I want to know the average number of answer choices a respondent selects for that question.

 

EX. A multi-answer question with 12 possible answers (and no caps on how many a respondent can colllect)

John selects 5 answer choices

Joe selects 4 answer choices

Jane selects 10 answer choices

Jess selects 1 answer choice

Average number of choices respondents selected would be 5.

I don’t know how to compute this value within Qualtrics, and the respondent count (2,000+) makes it harder to do by hand. Would be very grateful on any and all advice on how to solve this.

Best answer by Shashi

Give a score of 1 to each answer options. In the  dashboard widget use this score variable to get the average.

View original

4 replies

Shashi
Level 8 ●●●●●●●●
Forum|alt.badge.img+32
  • Shashi
  • Level 8 ●●●●●●●●
  • 633 replies
  • Answer
  • January 17, 2024

Give a score of 1 to each answer options. In the  dashboard widget use this score variable to get the average.

vgayraud
J
2 people like this
  • vgayraud
    vgayraud
  • J
    jake_dufinetz
J
QPN Level 2 ●●
Forum|alt.badge.img+5
  • jake_dufinetz
  • QPN Level 2 ●●
  • 20 replies
  • January 17, 2024

You can add an embedded data field to your survey flow to capture how many choices a respondent selected to a multi-select question. There is a hidden field for this using SelectedChoicesCount. With this value then saved to each response, you can then use an average metric in the dashboard. It would look something like the below:

Total_Selected_Choices = ${q://QIDX/SelectedChoicesCount}

 

L
1 person likes this
  • L
    lucindarp28
vgayraud
QPN Level 5 ●●●●●
Forum|alt.badge.img+49
  • vgayraud
  • QPN Level 5 ●●●●●
  • 388 replies
  • January 18, 2024

If your data is already collected, I would go with @Shashi ‘s solution, since scoring will apply retroactively to your data. You’ll just have to add it to your dashboard’s mapped fields.

Vincent Gayraud
J
L
2 people like this
  • J
    jake_dufinetz
  • L
    lucindarp28
J
QPN Level 2 ●●
Forum|alt.badge.img+5
  • jake_dufinetz
  • QPN Level 2 ●●
  • 20 replies
  • January 18, 2024
vgayraud wrote:

If your data is already collected, I would go with @Shashi ‘s solution, since scoring will apply retroactively to your data. You’ll just have to add it to your dashboard’s mapped fields.

Yes if data is already collected, very much agree with @Shashi above!

L
1 person likes this
  • L
    lucindarp28

Leave a Reply


Terms & Conditions