Mean of Multiple Questions | XM Community
Solved

Mean of Multiple Questions

  • 15 June 2023
  • 3 replies
  • 321 views
C
Rank
Userlevel 1
Badge +2

How can I get the average of 7 different questions without StatsiQ?

icon

Best answer by EmilyErickson 15 June 2023, 19:09

View original

3 replies

krbhavya
Rank
Userlevel 6
Badge +20

Hi @clee10109 

The easiest way to calculate the mean is create widgets on the dashboard.

Another way is to math operations in the survey flow

https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/

Bhavya Kumar
EmilyErickson
Rank
Userlevel 5
Badge +12

It sounds like you need averages per respondents:

You can do so from the Data & Analysis Tab:

Select the Field Editor, Create Field, Formula, and then enter a formula that adds the fields and divides them by the number of questions.

If the fields are for some reason text, get the recode values on their scale and then do the above.

When dashboarding, if you already have an active dashboard, you can go in and select the derived data on the data mapper and add it.

J
Rank
Userlevel 4
Badge +15

Hi @clee10109, 

 

Not sure your exact use case. Qualtrics is very flexible, and you can handle this in different ways based on your requirement.

  1. Using Embedded data and math operations - You can use math operation to calculate average across multiple questions (https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/)
  2. Using Scoring - You can also use scoring to calculate average. Scoring Calculations are retroactive (https://www.qualtrics.com/support/survey-platform/survey-module/survey-tools/scoring/)
  3. Using Custom Javascript - You can use javascript option to calculate average and store in embedded data using setEmbeddedData.
  4. Creating Custom Fields in Data and Analysis Tab - You can create custom fields and create formula for calculation. This calculation happens after record complete the survey. (https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/add-new-fields/formula-variable-creation/)
  5. Dashboard - You can also display average at dashboard level. However it is only for reporting. You can send email or download report to get average details periodically.

Hope this helps.

 

Thanks,

JB

Leave a Reply


Terms & Conditions