Simple mathematics question
Posted by: garyi on 17 April 2004
Guys I am hung over I should know this but:
I need to work out the percentage increase in sales over five figures.
i.e.
January £1500
February £1600
March £1750
April £1890
How do I show the avergae percentage increase between months. and the overal percenatge increase between January and April.
Cheers
Posted on: 17 April 2004 by Mick P
Gary
Percentage increase = (new price - old price) divided by old price
Eg the diference between January and April
= (1890 - 1500) divided by1500
= 390 divided by1500
=0.26 or 26%
Regards
Mick
Posted on: 17 April 2004 by ken c
try:
100 * (1/3) * ( (m2-m1)/m1 +(m3-m2)/m2 + (m4-m3)/m3 )
for the average monthly increase (over 3 months, hence the 1/3. what was bothering you?
enjoy
ken
Posted on: 17 April 2004 by garyi
Cheers Mick.
Posted on: 17 April 2004 by Laurie Saunders
quote:
Percentage increase = (new price - old price) divided by old price
....multiplied by 100!
Laurie S
Posted on: 17 April 2004 by garyi
Just reviewing some figures ready for a presentation next week.
Thanks
Posted on: 17 April 2004 by Don Atkinson
Guys I am hung over I should know this but:
I need to work out the percentage increase in sales over five figures.
i.e.
January £1500
February £1600
March £1750
April £1890
errrr.....there's only FOUR figures........just HOW hung over were you?????
the % increase Jan to Feb would be 6.67% (Micks method)
the % increase Feb to Mar would be 9.38% (Micks method)
the % increase Mar to Apr would be 8.00% (Micks method)
the average % increase Jan to Apr would be 8.02% (ken c's method) ie [6.67 + 9.38 + 8.00]/3
Cheers
Don
