Lets say we have 100 people.
10 of them wear red.
20 wear blue.
70 wear green.
20 people from this group wear glasses.
We know that 3 people in the red group wear glasses and five people in the green group wear glasses. This means the other 12 who wear glasses are in the green group.
If I was blindfolded and selected one person from the red group, what is the probability I will select a person with glasses?
If I was blindfolded and selected one person from the red group, what is the likelihood the person I selected will be wearing glasses?
If all three groups were combined and I selected one person while blindfolded, what is the probability and likelihood of selecting a red person with glasses?
Also, how can I calculate this in excel?