Whose good at percentages please? I have been trying to work this out for two hours using excel and I am defeated

[Myheadhurtsagain]

Hi, I am doing a Masters degree at the grand old age of 47. It's history based. My history is good, but my maths isn't! My head really hurts and I am truly stuck. Please can someone help me?!

I have to do select a proportion sample of two groups, and I just cannot work out how many in each group I need to select to make it correctly proportional.

I have put a screenshot on, but basically, I have two groups: survivors of a tragedy, and victims. I have to study 30 of the surviving fathers' children, and 90 of the victims' children.

They were separated into two different groups: A and B (which reflected their different shifts), and I have to make sure that my sample groups of children have the correct proportions of their fathers who were in group A, and those who were in group B.

So, survivors: 4 survivors in group A, and 18 in group B. Total 22 survivors.
Victims: 20 in group A and 78 in group B.

I have to study their children.

I need to select 30 of the survivors children and 90 of the victims children. I have not yet found the kids so don't know how many there are.

How many fathers do I need to select from groups A and B for survivors for it to be proportional?
Ditto for victims?

Many thanks

unless it specifies that it has to be randomised further than no more than 2 children per parent then I don’t see that it needs to be? But if you start by selecting 1 from each parent from each group you only need to go back for 8 extra and 12 extra to get to 30 and 90 if that makes sense?

Thank you, I see what you mean