It could be that it is too easy, but I cannot think of a formula or method that gives me the outcome I need. I have a data table containing 4 columns as below
I made an average on conversions vs chances, I made a cross table so that I can see that ID A made 7 conversions on 15 chances at position 1 etc. etc. But I want to filter on the couple of chances at a particular position, so that I can see the average conversions with a minimum amount of chances at that particular position. (It wouldn't be fair if person B would win with 100% conversion rate at position 6 while only having 2 chances, right?)
Hope I am clear on what I want to archieve, I hope you could help me.
Thanks in advance!