Help required-trying to create a distribution table
Hi I have some survey data where questions are answered with a score 0-6. I am trying to create a table/grid that show the % of respondents for a given score by item:
EG:
Header 1
Header 2
Header 3
Header 4
Header 5
Header 6
Header 7
Header 8
0
1
2
3
4
5
6
Item ID 1
5%
15%
20%
23%
17%
10%
10%
Item ID 2
3%
17%
23%
20%
10%
17%
10%
Any ideas where to start? Any suggestions gratefully received.
The data is stored as a filed called the ITEM ID# and consists of a series of scores between 0 and 6
