Skip to content
Advertisement

How to get percentage based on columns

so here is what I have:

I have a hired column which is boolean values, population which is either US or EU values. Right now the freq divides the hired over the entire population which is like 5,000 values but I would like it to divide which are specifically US or EU values.

Can anyone help me with doing this? thanks

Example data:

instead of dividing by the entire population I just want by like total of EU or US values

so like True in EU is 1 but total for EU is 3 so 1/3 instead of 1/6

Sample output:

Advertisement

Answer

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement