Forum Discussion
How do I make a comparison by percentage with 2 groups?
To calculate the total percentage comparison between the two groups in Excel, you can use the following formula:
- Calculate the total number of individuals in Group 1 and Group 2:
- For Group 1 (Column B), sum all the values in that column.
- For Group 2 (Column D), sum all the values in that column.
You can use the SUM function for this. Let's assume the total for Group 1 is in cell B22, and the total for Group 2 is in cell D22.
- Calculate the percentage difference:
In Excel, you can use the following formula to calculate the percentage difference:
=((B22-D22)/D22)*100
This formula will give you the percentage difference between the two groups. A positive percentage means that Group 1 has seen more individuals than Group 2, and a negative percentage means Group 1 has seen fewer individuals.
You can insert this formula in a cell to get the percentage comparison between the two groups based on the total number of individuals they've seen in their respective age groups. The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.