1 Reply Latest reply: May 11, 2017 12:43 PM by Stefan Wühl RSS

    Help required-trying to create a distribution table

    Peter Cowan

      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 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8
      0123456
      Item ID 15%15%20%23%17%10%10%
      Item ID 23%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