Math/Excel – How to Calculate Percentage Change

I am working on graphs and I need to find the percentage of increase from one figure to another. How do I do that? For instance staff hours for 2006 were 28011 and for 2007 were 31230. How do I find the percentage of increase?

Percentage change is calculated this way:

percentchange_1.1

The sign indicates whether it is a decrease or increase. For your example,

percentchange_1.2

  • Since this is a positive figure, it is an 11.5% increase.

    Hope this helps!

    Source: http://mathcentral.uregina.ca/QQ/database/QQ.09.06/s/galland1.html

 

Comments

comments

Recent Posts