How to determine relationship between two dimensions of a 3 x 3 frequency matrix?
April 10, 2012 12:16 PM Subscribe
Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel?
posted by Susurration to Science & Nature (10 answers total) 1 user marked this as a favorite
I have a matrix of data frequencies, collected from a qualitative data analysis. I need to analyze whether there is a relationship between the two dimensions of this matrix, but don't know which test to use, to determine this.
Project frequencies in each dimension, A or B, are summarized in a 3 x 3 matrix, e.g.
A-Low A-Med A-High
B-Low 20 35 13
B-Med 13 80 28
B-High 2 13 81
From these frequencies, it is clear that projects in A-Low are most likely to also be in category B-Low. Projects in category A-Med are most likely to also be in category B-Med. Projects in category C-High are most likely to also be in category B-High. I would like to measure the strength of the relationship between these variables, but I don't know what type of statistical test would be valid for these data. Any suggestions?
If can determine the strength of the relationship, how would I interpret the values of this measure of co-relationship?