I have a faculty member who has a survey where she has been exporting her data to figure the mean of the responses of 4 questions. Basically a mean of means for these 4 q's. I feel like this should be possible within Qualtrics or StatsIQ, but after digging around for quite a bit, can't figure it out. Can someone give me some direction? She's been using Excel to do this after exporting the data, but it'd be great if she could just create this within a custom Report or a StatsIQ report. Thank you!

Hello @MichelleC , Assuming you want the average of one column ( one question ) of the data and analysis tab then - Go to "Data & Analysis" -> "Analysis(StatsIQ)" -> "Create new variable" -> "Formula" -> "fx(Average column)"Now we have 4 averages of 4 questions, in formula bar we can create average of average as required.

@shashi, awesome. I will give that a try and report back. Thank you so much!

Develop mean for 4 grouped questions

Develop mean for 4 grouped questions | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded