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
View original