How to Calculate Averages in Qualtrics Before Exporting to Excel? | XM Community
Skip to main content
Question

How to Calculate Averages in Qualtrics Before Exporting to Excel?

  • February 20, 2025
  • 1 reply
  • 17 views

Forum|alt.badge.img+1

Hello,

I've been browsing the support pages on calculating totals and scores, but I haven't found any information on how to calculate simple averages, both across all participants and for individual participants, in a survey. I know I can do this in Excel using the AVERAGE formula, but I'd like to know if Qualtrics can calculate these averages for me so that they're already included when I export the file to Excel.

Does anyone know how to do this?

1 reply

MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • Level 6 ●●●●●●
  • 1069 replies
  • February 21, 2025

Hi,

I assume you’re referring to Excel files generated by Data Exports?

While it’s not possible to generate averages across participants (column averages), you can use Custom Formula Fields to calculate them within participants (row averages, like for a series of quiz scores).


Leave a Reply