How can I make a mean of multiple questions? | Experience Community
Skip to main content
JoseS
Administrator
1 year ago
Question

How can I make a mean of multiple questions?

  • Feb 28, 2020 11:21 AM UTC
  • 5 replies
  • 868 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+73
    • AdamK12
    • Level 5 ●●●●●
    • Feb 28, 2020 2:54 PM UTC
    @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"...
    Adam Korengold, NLM/SCI (he/him/his)
    Forum|alt.badge.img
    • ckashila
    • Author
    • Feb 28, 2020 3:09 PM UTC
    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+73
    • AdamK12
    • Level 5 ●●●●●
    • Feb 28, 2020 4:07 PM UTC
    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.
    Adam Korengold, NLM/SCI (he/him/his)
    • FDG2102
    • May 2, 2020 5:54 PM UTC

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

    Level 1 ●
    Forum|alt.badge.img+2
    • clee10109
    • Level 1 ●
    • Jun 14, 2023 11:50 PM UTC

    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?

    Terms & ConditionsAccessibility statement