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 crosstab 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 crosstab 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 coordinates.
 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
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