Solved
How to average matrix questions responses across questions and sub-choices?
_Caveat: I know that there are better ways to build out this survey, but unfortunately I'm in charge of analyzing the survey results, not editing the survey - the survey has already been created, distributed, and has about 200 responses._
I need to average matrix questions. For example, look at this survey
What I need is: A bar patron's overall satisfaction per question/category (averaging forks, spoons, and knives for silverware; averaging plates/bowls for tableware; averaging the three types of glassware). Then, a bar patron's overall satisfaction - averaging literally all of it. Then, both of the above for restaurant patrons. Then, both of the first two for all patrons.
My goal for that example survey is this:
* "Bar patrons have an average satisfaction of 3.5/5 for silverware, 1.5/5 for tableware, and 4/5 for glassware. They have an overall satisfaction with the restaurant of 3/5."
* "Dining room patrons have an average satisfaction of 3/5 for silverware, 5/5 for tableware, and 3/5 for glassware. They have an overall satisfaction with the restaurant of 3.7/5."
* "Overall, the total satisfaction of the restaurant is 3.2/5 for silverware, 3.25/5 for tableware, and 3.75/5 for glassware."
* "The overall entire satisfaction of everyone with all aspects of the restaurant is 3.3/5"
I know how to get satisfaction on a single item using crosstabs - for example, just forks. But combining the different parts of the question or all questions - do you know? I think I can bucket together bar and restaurant patron, but I don't know how to combine the matrix questions.
Any and all help is appreciated. Thanks!
Best answer by KendraR
Hey, @riceball! Just wanted to jump in here and say that you may be able to accomplish this with the scoring functionality. However, since the solution to what you are trying to achieve may vary based on how your survey is set up, I would recommend that you reach out to our Support Team so that they can take a look with you. 😃
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
