How do I calculate percentage increase over time?
Here are the steps to calculate a percentage increase over time:
-
If you know the percentage change, go directly to step 4. Otherwise, subtract initial value from the final value.
-
Divide the difference from the previous step by the modulus of the initial value (i.e., the initial value without the minus sign).
-
Multiply this new number by 100. You now have the percentage change.
-
Divide the percentage change by the period of time between the two numbers.
-
You now have the percentage increase over time. Remember that the units will be % / [time], where time is the unit you divided by (e.g., seconds).
-
For linear plots, multiply this number by any time difference to get the percentage change between the two times.
-
For non-linear plots, just replace the larger number with your equation and solve algebraically. This will only find the percentage change between a number you input and the original number.
Where is percentage increase useful?
Percentage increase is useful when you want to analyze how a value has changed over time. Although the percentage increase is very similar to the absolute increase, the former is more useful when comparing multiple data sets. For example, a change from 1 to 51 and from 50 to 100 both have an absolute change of 50.
However, the percentage increase for the first is 5000%, while for the second, it is 100%, so the first change grew relatively a lot more. This is why percentage increase is the most common way of measuring growth.
How do I calculate percentage increase in Excel?
While it's easier to use Omni's Percentage Increase Calculator, here are the steps to calculate the percentage increase in Excel:
-
Input the original number (for example, into cell A1).
-
Input the increased number (for example, into cell B1).
-
Subtract the original number from the increased number (In C1, input =B1-A1) and label it 'difference'.
-
Divide the difference by the original price and multiply it by 100 (In D1, input =(C1/A1)*100) and label it 'percentage increase'.
-
Right-click on the final cell and select Format Cells.
-
In the Format Cells box, under Number, select Percentage and specify your desired number of decimal places.