Hello,
I have the following matrix:
Where the rows and columns of the same number represent the same store (Store 1, store 2, etc). The numbers on the matrix represent the amount of times in a year they've purchased from each other.
I would like to create a variables that creates a group, like a cluster, of the observations that are "similar". That is, instead of doing one myself by looking at it, creating something that's more statistically robust I guess.
Is there a way to do this?
Naturally, I know that c1,r2 represents the impact of store 1 on store 2's sales, and c2,r1 represents the impact of store 2 on store 1's sales, and this makes things difficult. Maybe I could do like an average of the 2, just to have like half a matrix. I just want the mechanics of this, or even if it's possible, in Stata.
Thank you in advance,
Anthoine
I have the following matrix:
Code:
mat li e e[12,12] c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 r1 0 0 0 6 7 5 90 4 0 0 0 0 r2 0 0 89 6 11 9 9 14 14 0 53 9 r3 0 0 0 0 0 11 0 0 0 13 0 0 r4 20 0 5 0 9 0 2 0 10 7 0 33 r5 2 0 82 0 0 22 16 3 0 0 0 6 r6 0 0 1 0 9 0 0 0 0 25 0 0 r7 0 9 0 11 0 0 0 71 0 0 0 13 r8 0 0 11 2 0 0 0 0 0 0 0 0 r9 4 33 0 4 2 16 0 13 0 0 25 15 r10 0 0 0 0 0 0 0 0 0 0 31 0 r11 0 0 87 0 0 0 0 55 0 0 0 100 r12 5 3 0 9 7 2 0 0 2 0 0 0
I would like to create a variables that creates a group, like a cluster, of the observations that are "similar". That is, instead of doing one myself by looking at it, creating something that's more statistically robust I guess.
Is there a way to do this?
Naturally, I know that c1,r2 represents the impact of store 1 on store 2's sales, and c2,r1 represents the impact of store 2 on store 1's sales, and this makes things difficult. Maybe I could do like an average of the 2, just to have like half a matrix. I just want the mechanics of this, or even if it's possible, in Stata.
Thank you in advance,
Anthoine
Comment