1 Reply Latest reply on May 28, 2013 2:53 AM by Jim Wahl

    Scatter Plot of two items in a dimension

    Anuja S Krishnan

      How can I create a scatter plot to compare two items from a single column in my data?

       

      For e.g. the data looks like something below:

       

      Person

      Quartiles

      A

      1

      B

      2

      C

      1

      D

      2

      E

      Rest

      A

      Rest

      A

      Rest

      B

      Rest

       

      I managed to create a cross-tab based on the above data which shows the frequency of items in the "Quartiles" columns by Person. My next step would be to show these counts as %.

       

      Person

      1

      2

      Rest

      A

      1

      0

      2

      B

      0

      1

      1

      C

      1

      0

      0

      D

      0

      1

      0

      E

      0

      0

      1

       

      The cross-tab that I am actually trying to create (but having a problem doing this!) should look like this one below. Of course the data here is just an e.g. and will probably not show any meaningful plots but this is the idea. In my actual data these will be bigger numbers (percentages). The scatters will be A, B, C, D, E which will appear in the plot based on their co-ordinates.

       

       

      1

      0

      1

      0

      0

      A

      0

       

       

       

       

      B

       

      1

       

       

       

      C

       

       

      0

       

       

      D

       

       

       

      1

       

      E

       

       

       

       

      0

       

      I hope I have been clear enough!

      Thanks in advance

        • 1. Re: Scatter Plot of two items in a dimension
          Jim Wahl

          Hi Anuja,

           

          I'm still struggling to understand how you get the final crosstab. The header looks like the first column of the second crosstab? What do the values represent?

           

          Perhaps you could post the data in Excel?

           

          And you ultimate goal is a scatter plot, not a crosstab? In this case, both axes will have to be continuous. You can convert A, B, C, ... to continuous, but the data may make a difference in how you do this.

           

          Jim