Hi!
First of all, thanks for taking the time to read this.
I have a set of data (AdvPreTest) in which I have different advertisements (let's say advertisements Adv1, Adv2, Adv3, Adv4, and Adv5) classify by groups (group1, group2, group3) based on their similarities. What I want to know is how many times each advertisements were grouped together. E.g. how many times were Adv1 and Adv2 were grouped / consider similar. The number of the group in which they are is not important.
My data are like
Name Groups Value
AB282 group1 Adv1
AB282 group1 Adv2
AB282 group1 Adv3
AB282 group2 Adv4
AB282 group2 Adv5
AB20 group3 Adv1
AB20 group3 Adv2
AB20 group2 Adv3
AB20 group2 Adv4
AB20 group2 Adv5
LM28 group3 Adv1
LM28 group3 Adv2
LM28 group3 Adv3
LM28 group2 Adv4
LM28 group2 Adv5
GM25 group2 Adv1
GM25 group2 Adv2
GM25 group2 Adv3
GM25 group1 Adv4
GM25 group1 Adv5
And at the end I hope to have something like
Adv1 Adv2 Adv3 Adv4 Adv5
Adv1 X 4 3 0 0
Adv2 4 X 3 0 0
Adv3 3 3 X 1 1
Adv4 0 0 1 X 4
Adv5 0 0 1 4 X
But I have no idea how to compute this.
Thanks for your time and your help.