Hello,
I am trying to create a matrix of constituents in our database comparing their Relationships to other constituents. I have a list of constituents, and each one has a list of people they have relationships with (represented here are constituent IDs for people attached to their record as a relation).
What I would like to do is the relationship list for every person in our database to every other person in our database, and identify people who share the highest number of relationships in common.
So here is a list of constituents, the ID#s of each person listed as a relationship (could just as easily be their names). Below I used the Correlation Analysis from the Data Analysis Toolpak.
John and Dwight have no one in common, so their score should be zero, right? I think the issue is that my numbers are not actually that, they're random ID#s representing a person. But I can't use the Correlation Matrix on non-numeric data.
Is there a canned analysis tool or downloadable spreadsheet with formulas that will do what I want?
Thanks so much,
Heather
I am trying to create a matrix of constituents in our database comparing their Relationships to other constituents. I have a list of constituents, and each one has a list of people they have relationships with (represented here are constituent IDs for people attached to their record as a relation).
What I would like to do is the relationship list for every person in our database to every other person in our database, and identify people who share the highest number of relationships in common.
So here is a list of constituents, the ID#s of each person listed as a relationship (could just as easily be their names). Below I used the Correlation Analysis from the Data Analysis Toolpak.
John and Dwight have no one in common, so their score should be zero, right? I think the issue is that my numbers are not actually that, they're random ID#s representing a person. But I can't use the Correlation Matrix on non-numeric data.
Is there a canned analysis tool or downloadable spreadsheet with formulas that will do what I want?
Thanks so much,
Heather