How can I make a mean of multiple questions? | XM Community
Skip to main content
Question

How can I make a mean of multiple questions?

  • February 28, 2020
  • 5 replies
  • 678 views

Forum|alt.badge.img
Hello, I've 10 questions (Matrix Table: Likert - 6 statements 5 scale points each) that I need to take the values and make a mean of them. I can't figure out how to and would appreciate some help. Thanks in advance

5 replies

AdamK12
Level 5 ●●●●●
Forum|alt.badge.img+59
  • Level 5 ●●●●●
  • 299 replies
  • February 28, 2020
@ckashila You can do this in Stats IQ-go to the Data and Analysis tab and choose "Collect or Clean Variable." Choose "Formula" as the option to assign new variables and then choose "Average"...

Forum|alt.badge.img
  • Author
  • 1 reply
  • February 28, 2020
Thank you @AdamK12 , but I don't have the Satats IQ extension. Is there any other way to do this? Tried "Creating a new Field > New Variable" but it only let's me use 40 variables each time and I need more.

AdamK12
Level 5 ●●●●●
Forum|alt.badge.img+59
  • Level 5 ●●●●●
  • 299 replies
  • February 28, 2020
Another option would be to export the data set and create a new field in your preferred data analysis tool (Excel, Tableau, SPSS, R, etc.) where you average the 10 fields, and then analyze the results. That's probably the easiest thing to do.

  • 2 replies
  • May 2, 2020

Is there a way to do this in Qualtrics so that I can get the mean to be pulled into a report?


Forum|alt.badge.img+2
  • Level 1 ●
  • 1 reply
  • June 14, 2023
FDG2102 wrote:

Is there a way to do this in Qualtrics so that I can get the mean to be pulled into a report?

Is there a way to do this? ^ 
Also, how can I create a new variable to pull an average from 7 questions without the StatsiQ options?


Leave a Reply