software

Thanks to people's answers I have managed to create a basic correlation
scattergram. I only have 18 participants, each with two values to correlate.
However if two participants have the same results only one point is shown.
Therefore my scattergram only shows eight points when there are 18 values.
Does that make sense? If I was doing it manually I would simply put two marks
where two participants fall, pretty simple, but can't find how to do this in
excel.
Any help would be great.

A surface plot may help. It can be used to show the frequency of
occurrence of data pairs.

HTH,
JohnStressed -

You could use a manual method of quot;jittering.quot;

For the data set being plotted, where there are two identical values, change
the worksheet values of either X or Y or both slightly so that two markers
will appear.

- Mike
www.mikemiddleton.com

quot;Stressed Dissertation Authorquot; lt;Stressed Dissertation
gt; wrote in message
news
gt; Thanks to people's answers I have managed to create a basic correlation
gt; scattergram. I only have 18 participants, each with two values to
gt; correlate.
gt; However if two participants have the same results only one point is shown.
gt; Therefore my scattergram only shows eight points when there are 18 values.
gt; Does that make sense? If I was doing it manually I would simply put two
gt; marks
gt; where two participants fall, pretty simple, but can't find how to do this
gt; in
gt; excel.
gt; Any help would be great.