Question: I would like to be able to create a crosstabulation of data that was provided. there was a survey that as administered to 25 people,
I would like to be able to create a crosstabulation of data that was provided. there was a survey that as administered to 25 people, where 14 questions were asked. they were questions on a scale of 1-5 below are the responses.
| Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Gender | Age | Marital Status | Ed Level | Income | |
| 1 | 5 | 4 | 5 | N/A | 4 | 1 | 2 | N/A | 1 | 1 | 1 | 5 | 5 | 5 | 2 | 3 | 2 | 1 | 1 |
| 2 | 5 | 5 | 5 | 4 | 5 | 1 | 2 | N/A | N/A | N/A | N/A | 5 | 4 | 5 | 2 | 5 | 3 | 3 | 5 |
| 3 | 5 | 4 | 5 | 4 | 4 | 1 | N/A | N/A | 1 | 1 | 1 | 4 | 4 | 4 | 2 | 1 | 1 | 3 | 3 |
| 4 | 5 | 5 | 4 | 5 | 4 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 2 | 2 | 1 | 3 | 3 |
| 5 | 4 | 5 | 4 | 2 | 4 | 1 | 2 | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 1 | 3 | 2 | 3 | 5 |
| 6 | 4 | 4 | 4 | 4 | 3 | 1 | 2 | 2 | 1 | 1 | N/A | 5 | 5 | 5 | 2 | 3 | 1 | 3 | 4 |
| 7 | 4 | 4 | 5 | 4 | 3 | 1 | 2 | 2 | 1 | 1 | 1 | 4 | 3 | 4 | 1 | 4 | 2 | 1 | 5 |
| 8 | 4 | 5 | 5 | N/A | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 2 | 4 | 2 | 1 | 2 |
| 9 | 4 | 4 | 4 | 4 | 3 | 1 | 2 | 2 | 2 | 2 | 2 | 5 | 5 | 5 | 2 | 2 | 1 | 3 | 3 |
| 10 | 5 | 4 | 5 | 3 | 4 | 1 | 2 | N/A | 1 | 1 | 1 | 5 | 4 | 4 | 2 | 2 | 2 | 3 | 4 |
| 11 | 5 | 5 | 5 | 4 | 5 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 4 | 1 | 4 | 5 |
| 12 | 5 | 5 | 5 | 4 | 4 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 3 | 1 | 1 | 4 |
| 13 | 5 | 4 | 5 | 4 | 5 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 3 | 1 | 1 | 4 |
| 14 | 5 | 4 | 5 | 4 | 4 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 3 | 2 | 1 | 3 |
| 15 | 5 | 4 | 4 | 3 | 4 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 1 | 1 | 1 | 2 |
| 16 | 4 | 4 | 4 | 4 | 3 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 2 | 2 | 2 | 1 | 5 |
| 17 | 5 | 4 | 5 | 5 | 5 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 2 | 1 | 1 | 4 |
| 18 | 4 | 5 | 4 | 5 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 4 | 4 | 5 | 2 | 4 | 2 | 3 | 2 |
| 19 | 4 | 4 | 3 | 3 | 5 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 3 | 4 | 2 | 2 | 2 | 3 | 2 |
| 20 | 4 | 5 | 5 | 5 | 4 | 1 | 2 | 2 | 1 | 1 | 1 | 4 | 4 | 5 | 1 | 3 | 1 | 1 | 1 |
| 21 | 4 | 5 | 5 | 5 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 4 | 4 | 5 | 2 | 3 | 3 | 3 | 2 |
| 22 | 4 | 5 | 4 | 2 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 2 | 1 | 1 | 2 |
| 23 | 5 | 5 | 4 | 4 | 3 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 1 | 1 | 1 | 1 | 4 |
| 24 | 4 | 4 | 5 | 5 | 5 | 1 | 2 | 2 | 1 | 1 | 1 | 5 | 5 | 5 | 2 | 4 | 3 | 3 | 3 |
| 25 | 5 | 4 | 4 | 5 | 4 | 1 | 2 | 2 | 2 | 1 | 1 | 5 | 5 | 5 | 2 | 3 | 3 | 2 | 1 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help