M
murpm3
Guest
Ok here is my problem that I need some help on:
I have some survey data....I need to produce reports based on how many people had chosen a given answer.
The answers were based on a "1-7" scale. I have 13 Questions...Each in a different field. In those fields the data is like I said, a single number from 1-7.
Anyways, how do I specifically count the number of 1s, 2s, 3s, 4s etc...
I want my report to look something like this:
Q1 Q2 Q3
1 35 45 24
2 12 25 44
3 2 9 25
So that is how it should look....Question names on top, and on the left the corresponding answer they picked. I can figure out how to format the information.
But what do I have to do to come up with those totals....How do I count the total number of 1s etc....
Thank you so much for your help.
I have some survey data....I need to produce reports based on how many people had chosen a given answer.
The answers were based on a "1-7" scale. I have 13 Questions...Each in a different field. In those fields the data is like I said, a single number from 1-7.
Anyways, how do I specifically count the number of 1s, 2s, 3s, 4s etc...
I want my report to look something like this:
Q1 Q2 Q3
1 35 45 24
2 12 25 44
3 2 9 25
So that is how it should look....Question names on top, and on the left the corresponding answer they picked. I can figure out how to format the information.
But what do I have to do to come up with those totals....How do I count the total number of 1s etc....
Thank you so much for your help.