Correlation between two sets of categorical variables

[missedw]

Hi,

Been researching this for a while and can't find an example of how to set this up with Excel formula.

I have two sets of categorical variable (ie yes/no answers) and I want to find the correlation between them

Example:

	Filled out notes field	Did not fill out notes field
Bought	1200	645
Did not buy	890	750

<tbody>
</tbody>

How would I go about working this out in Excel? I have a rudimentary understanding of statistics from a long time ago at uni but am definitely a bit rusty! If anyone could help me that would very much appreciated.

 

[oldbrewer]

all I can conclude is more of the "bought" did fill out a notes field (46%) than did not buys at 16%

is that statistically significant - I would read up on null hypothesis and probably find an excel example or if not put the formula on here and someone will convert it.