data have;
input ex1_1 ex1_2 ex1_3 ex1_4 ex2_1 ex2_2 ex2_3 ex2_4 ex3_1 ex3_2 ex3_3 ex3_4 sum_ex1 sum_ex2 sum__ex3 ;
cards;
0.30 1.31 2.12 1.20 0.20 1.62 0.89 3.46 0.27 1.39 1.69 1.584.9 3 4.93 6.16;
sum_ex1 is the sum of ex1_1 ex1_2 ex1_3 ex1_4 and likewise
sum_ex2 is the sum of ex2_1 ex2_2 ex2_3 ex2_4.
sum_ex3 is the sum of sx3_1 ex3_2 ex3_3 ex3_4.
Ex1_1 is first person's first score, Ex1_2 is first person's second score
Ex2_1 is second person's first score Ex2_2 is second person's second score.
.
.
.
Btw, I already have all sum_ex variables.
With the equation I want, I'll have three p_m variables with that data (pm1_2 is probabilities between 1. and 2.person ; pm1_3 probabilities between 1. and 3. person and likewise for person 2 and 3)
pm1_2= (ex1_1/sum_ex1)*(ex2_1/sum_ ex2)+(ex1_2/sum_ex1)*(ex2_2/ sum_ex2)+(ex1_3/sum_ex1)*(ex2_ 3/sum_ex2)+(ex1_4/sum_ex1)*( ex2_4/sum_ex2)
pm1_3=(ex1_1/sum_ex1)*(ex3_1/ sum_ex3)+(ex1_2/sum_ex1)*(ex3_ 2/sum_ex3)+(ex1_3/sum_ex1)*( ex3_3/sum_ex3)+(ex1_4/sum_ex1) *(ex3_4/sum_ex3)
pm2_3=(ex2_1/sum_ex2)*(ex3_1/ sum_ex3)+(ex2_2/sum_ex2)*(ex3_ 2/sum_ex3)+(ex2_3/sum_ex2)*( ex3_3/sum_ex3)+(ex2_4/sum_ex2) *(ex3_4/sum_ex3)
As I said in this case I have only 3 people's values, however I will have 5,000 people.
I hope this is helpful.
... View more