Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

Develop mean for 4 grouped questions

MichelleC
MichelleC East Lansing, MIFounding Community Member, Community Member Sage ✭✭✭
edited June 22 in Stats iQ

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!

Tagged:

Best Answer

  • [Deleted User]
    [Deleted User] Qubie ✭
    Accepted Answer

    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.

Answers

  • MichelleC
    MichelleC East Lansing, MIFounding Community Member, Community Member Sage ✭✭✭

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