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!
Page 1 / 1
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.
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!
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.