Question
I need help with the following question. I am not sure how to group values in excel, but I know that there is a way.
I need help with the following question. I am not sure how to group values in excel, but I know that there is a way. I need to group all the male responses for overall satisfaction together, and all the male responses for retention together, and then do the same for female. But I need a step by step breakdown of how to group these values in excel after a pivot table is created.
Question:
Overall satisfaction (Q15) and retention (Q16) are measured on a 5-point scale. Compute mean and standard deviation for these variables for overall, male and female groups and format it as shown in the table below.
| Gender | Overall Satisfaction | Retention | For Gender | |
| 2 | 4 | 1 | 1 = Male | |
| 1 | 4 | 2 | 2 = Female | |
| 2 | 3 | 1 | ||
| 2 | 5 | 1 | For Overall Satisfaction | |
| 1 | 4 | 3 | 1 = Very unsatisfied | |
| 2 | 3 | 4 | 2 = Somewhat unsatisfied | |
| 2 | 4 | 3 | 3 = Neither unsatisfied nor satisfied | |
| 1 | 3 | 3 | 4 = Somewhat satisfied | |
| 1 | 4 | 3 | 5 = Very satisfied | |
| 2 | 4 | 3 | ||
| 1 | 3 | 4 | For retention | |
| 2 | 3 | 5 | 1 = Very likely to stay with this facility | |
| 1 | 4 | 3 | 2 = Somewhat likely to stay with this facility | |
| 2 | 1 | 5 | 3 = Neither likely nor unlikely | |
| 1 | 5 | 3 | 4 = Somewhat unlikely to stay with this facility | |
| 1 | 2 | 4 | 5 = Very unlikely to stay with this facility | |
| 1 | 3 | 2 | ||
| 1 | 3 | 3 | ||
| 1 | 4 | 3 | ||
| 1 | 1 | 3 | ||
| 1 | 3 | 4 | ||
| 2 | 2 | 4 | ||
| 1 | 3 | 4 | ||
| 1 | 2 | 3 | ||
| 1 | 3 | 3 | ||
| 1 | 3 | 4 | ||
| 1 | 3 | 4 | ||
| 1 | 1 | 1 | ||
| 1 | 2 | 5 | ||
| 1 | 4 | 3 | ||
| 2 | 3 | 2 | ||
| 1 | 3 | 3 | ||
| 1 | 4 | 3 | ||
| 1 | 4 | 3 | ||
| 1 | 4 | 3 | ||
| 2 | 4 | 3 | ||
| 1 | 4 | 3 | ||
| 1 | 3 | 2 | ||
| 1 | 3 | 3 | ||
| 1 | 2 | 5 | ||
| 2 | 3 | 3 | ||
| 1 | 3 | 2 | ||
| 1 | 4 | 3 | ||
| 1 | 4 | 3 | ||
| 1 | 3 | 3 | ||
| 1 | 2 | 4 | ||
| 1 | 3 | 3 | ||
| 2 | 4 | 3 | ||
| 1 | 5 | 2 | ||
| 2 | 4 | 3 | ||
| 1 | 4 | 3 | ||
| 2 | 5 | 2 | ||
| 1 | 3 | 1 | ||
| 2 | 3 | 3 | ||
| 2 | 3 | 3 | ||
| 1 | 3 | 5 | ||
| 1 | 4 | 3 | ||
| 2 | 3 | 1 | ||
| 1 | 4 | 3 | ||
| 1 | 2 | 3 | ||
| 2 | 3 | 3 | ||
| 1 | 2 | 1 | ||
| Satisfaction | Retention | |||
| Gender | Mean | SD | Mean | SD |
| Male | ||||
| Female | ||||
| Total |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Probability Theory A Concise Course
Authors: Y A Rozanov
1st Edition
0486321142, 9780486321141
