Forum Discussion
How do I make a comparison by percentage with 2 groups?
I have two columns of 2 different age groups. How do I compare by percentage to 2 groups
Good morning,
I have 2 groups - 0-20 age (b) group and 21-up age (d) group. I am asked to get the total % comparison.
Would appreciate your assistance.
Saida
percentage comparison in the difference between how many were seen from group b to group d.
- Good afternoon,
I have an excel spreadsheet. On that spreadsheet, I have two rows of information on the “B” column I have Individuals from the age of 0-20 years that have had service. On “D” column I have individuals from 21-and up years of age, that have had service. I need to figure out what is the total percentage comparison to how many more or less was seen in column “B” to “D” and vice versa.
You have Group 1 is the "B" Group and Group 2 is the "d" group. Let's say Joe Park Avenue Group 1 saw -40 individuals, Michael saw 78 and Mary saw 215 in the 0-20 age group and John Bear Claws saw 165, Peter saw 23, Pavel saw 144 and Sarah saw 0 in the 21 and up age group. comparing columns B and D what formula would tell me in total percent comparison or comparison in percentage.Perhaps you may share at least screenshot? What exactly means "Mary saw 215" - it means name Mary is repeated 215 times in column B or what?
