Hi,
Is there anyone who can help me figure out the probability of each number on the different A-B-C so that it will be like the answer to the right.
Preferably with VBA.
<colgroup><col span="5"><col span="3"><col><col><col span="3"></colgroup><tbody>
</tbody>
Is there anyone who can help me figure out the probability of each number on the different A-B-C so that it will be like the answer to the right.
Preferably with VBA.
Match | % | % | % | Probability % A | Probability % B | Probability % C | Number of Right | Probability % A | Probability % B | Probability % C | ||
1 | 14 | 25 | 61 | 61 | 25 | 14 | 13 | 0,06 | 0,00 | 0,00 | ||
2 | 92 | 6 | 2 | 92 | 6 | 2 | 12 | 0,60 | 0,00 | 0,00 | ||
3 | 49 | 30 | 21 | 49 | 30 | 21 | 11 | 2,86 | 0,00 | 0,00 | ||
4 | 50 | 27 | 23 | 50 | 27 | 23 | 10 | 8,26 | 0,01 | 0,00 | ||
5 | 69 | 20 | 11 | 69 | 20 | 11 | 9 | 16,01 | 0,07 | 0,00 | ||
6 | 48 | 30 | 22 | 48 | 30 | 22 | 8 | 21,93 | 0,39 | 0,04 | ||
7 | 48 | 30 | 22 | 48 | 30 | 22 | 7 | 21,80 | 1,66 | 0,26 | ||
8 | 49 | 28 | 23 | 49 | 28 | 23 | 6 | 15,87 | 5,24 | 1,29 | ||
9 | 56 | 25 | 19 | 56 | 25 | 19 | 5 | 8,42 | 12,25 | 4,70 | ||
10 | 28 | 29 | 43 | 43 | 29 | 28 | 4 | 3,20 | 20,95 | 12,39 | ||
11 | 64 | 22 | 14 | 64 | 22 | 14 | 3 | 0,84 | 25,54 | 23,12 | ||
12 | 67 | 19 | 14 | 67 | 19 | 14 | 2 | 0,14 | 21,02 | 28,93 | ||
13 | 19 | 30 | 51 | 51 | 30 | 19 | 1 | 0,01 | 10,48 | 21,79 | ||
0 | 0,00 | 2,39 | 7,47 | |||||||||
100% | 100% | 100% | ||||||||||
This is the correct answer |
<colgroup><col span="5"><col span="3"><col><col><col span="3"></colgroup><tbody>
</tbody>