Solved

Mean of Multiple Questions

+2

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

Best answer by EmilyErickson

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.

+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

+13

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.

+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.

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/)
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/)
Using Custom Javascript - You can use javascript option to calculate average and store in embedded data using setEmbeddedData.
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/)
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

Sign up