$Relative percentage increase / decrease$

Question

$Relative percentage increase / decrease$

Hello, everyone. First time posting here. I am not a mathematician and I have only the most basic knowledge of statistics. But as luck would have it, I wish to calculate something that I'm not sure how to do. I can do without it, but I'd like to include this in my analysis.

My problem is as follows: I want to know if it's possible to calculate the percentage increase or decrease of B from one year to the next, relative to the overall increase or decrease of A, which B is a part of. For example, how would I calculate the percentage of increase / decrease of black cats born in 2020 and 2021, relative to the number of all cats born in 2020 and 2021?

If, for example 100 black cats were born in 2020 and a total number of cats in 2020 was 1000, and 200 black cats were born in 2021 out of the total of 500 cats in that year, what is the percentage increase of black cats relative to the population of total born cats? I assume that it's different (greater in this case) than just the simple increase without taking into consideration the total population of cats.

Also, same for decrease.

I've attached the excel file with concrete numbers that I need, but I'd really apreciate the formula so that I could calculate it myself.

Statistics

Matchmaticians Alumnus

Matchmaticians Relative percentage increase / decrease File #1

File #1 (xlsx)

Report

Answer

The answer is accepted.

Join Matchmaticians Affiliate Marketing Program to earn up to 50% commission on every question your affiliated users ask or answer.

Answer 1

Answers can be viewed only if

The questioner was satisfied and accepted the answer, or
The answer was disputed, but the judge evaluated it as 100% correct.

View the answer

Percentage increase/decrease relative to total cats (of which year previous or current ?) Statement is incomplete and absurd I feel.
We can solve for it by taking it for current year. But one thing is for sure if you want to calculate that then it is useless to calculate. There is no point to calculate relative to any year, since total cats in all the years are changing as well.

But still if you wish to calculate that relative to current year, then use this formula as per the concepts of relative change in percentages:
Percentage change in black cats from 2020 to 2021 relative to current year is equal to $$=\frac{black_{2021}-black_{2020}}{total_{2021}}\times100$$
Moreover if you wish to find the same relative to the total cats in both years as you indicated in question then it would be:
$$\frac{black_{2021}-black_{2020}}{total_{2021}+total_{2020}}\times100$$

However I can tell you for analysing the data or interpretation of any analytics of the data given, the above expressions are meaningless and useless. They can't tell you anything to predict or extrapolate.
Instead you might want to find percentage increase of particular type of cats or total cats of each successive year or between two particular years.
For example:
$$=\frac{black_{2021}-black_{2020}}{black_{2020}}\times100$$
You can plot the graph of the same to extrapolate the data to predict the favourable scenario for any project purpose.

Aman R

Matchmaticians Alumnus

0

I actually suspected that it is useless and absurd, which is why I stated that I can do without this data. But since this is not my area of expertise I needed an opinion of someone who actually knows what they're talking about. Thanks.
Aman R

0

Thank you for the tip and feedback :)

$Relative percentage increase / decrease$

Answer

Related Questions

Search