Table Averages are not Correct | XM Community
Solved

Table Averages are not Correct

  • 5 December 2023
  • 1 reply
  • 43 views
P
Badge +1

This is my first question so I hope I am asking this in the right area. I have set up a matrix table question using a Standard Likert format. Using the Results tab I set up a table that is supposed to have the average score per statement. However, the averages shown in the results table are higher than possible. 5 should be the maximum possible. The responses recorded are 10 “test responses”. Can I get advice on how to set this up so the averages display correctly? 

 I’ll do my best to include screenshots of each “set-up”. 

Question:

Table in the Results tab: (a preceding question asks about what term is being rated)

Results Table Setup: 

Scoring Setup: 

Any advice on what I need to change? 

icon

Best answer by petevan 6 December 2023, 19:56

View original

1 reply

P
Badge +1

I worked with Qualtrics customer support on this and got it working. The solution was, while in the survey builder go to tools and then “Recode Values” and then “Reset recode values to sequential numbers for all questions” Apparently my answer choices were out of sequence and this was throwing off the averages. After the values were reset sequentially the report looked great. 

Leave a Reply


Terms & Conditions