Math question...

example:

25 to 100 = 400% increase
50 to 100 = 100% increase
100 to 150 = 50% increase

Those examples are all easy enough to figure out in your head, but what would be the forumula that is entered into a spreadsheet to generate the percentage increase between the 1st number and the 2nd?

I guess you all can tell why I'm not an accountant

but let's see who can add 1'-4 13/16" to 7'-9 3/8" quicker than me

[AzKidd69]

=(newvalue/originalvalue) *100
=(value2/value1)*100

edit had em backwards....

Nope... that's what I originally though too, but that method shows how much the 2nd number is larger than the 1st, not the increase in percentage.... does that make sense?

100 divided by 25 times 100 = 400 - Correct Percentage


100 divided by 50 times 100 = 200 - Incorrect Percentage


150 divided by 100 times 100 = 150 - Incorrect Percentage

In the 3rd example, 150 is only a 50% increase over 100, not a 150% increase like the forumula (=(value2/value1)*100) produces.

[I_W]

(( New Number - base number)/base number ) * 100%
or
[ Difference / Base ] * 100%


For examle your

50 and 100

If 50 is in A5 and 100 is in B5 the answer in C5 would have the formula:

=((B5-A5)/A5)*100

OR leave off the times 100 and format that column as PERCENT.

--------------------------
You want to compare the INCREASE (100-50 = 75) to the original number (50) and multiply by 100 for percent.


I suspect there may actually be a built in funcition in Excel to do this but it's more trouble to try to find it than it is to do the simple arithmetic.

[OuTpaTienT]

25 to 100 = 400% increase (wrong Fingers )
50 to 100 = 100% increase
100 to 150 = 50% increase
a to b = % i



b - a / (0.01 · a) = i%

150 - 100 / 1.00 = 50%

100 - 50 / 0.50 = 100%

100 - 25 / 0.25 = 300% (<---right)

--------------------------------------------------
test

33 to 166 = 403% increase
100 to 125 = 25% increase
150 to 300 = 100% increase
333 to 999 = 200% increase
248 to 309 = 24.6% increase
4 to 24 = 500% increase
87 to 94 = 8% increase
99 to 100 = 1.0101010101010101% increase


Is am right? Or just so stupid I can't see that I'm wrong?

Well .... now I don't feel quite as bad as I did.


...but isn't 100 4 times as much as 25... thus a 400% increase, not 300%?

ditto with 1 and 10, I would have thought that to be a 1000% increase, not 900%?

[OuTpaTienT]

Think about it.

If it were
25 to 25 = 0% increase
25 to 50 = 100% increase
25 to 75 = 200% increase

so
25 to 100, must be a 300% increase

100 is 400% of 25, correct. But you want to state what the increase is, not what the final number is...right?

It's a 75 unit increase...from 25 to 100. And 75 is 300% of 25.

uT

I got ya buddy

I must have missed the day we learned percentages, because 25 --> 75 looks like a 300% increase to me and
25 --> 100 looks like 400% but the numbers just don't add up that way

Thanks I_W for providing the forumula, and thanks OuT for helping me grasp it

[osprey4]

This is how the media does "How to lie with statistics".

Take the 25 increasing to 100. You want to minimize the impact of this increase. "This amount has increased to 100 from its low of 25."

You want to state the facts as simply as possible. "The amount has quadrupled from 25 to 100."

How to emphasize the increase. "There has been an increase of 300% since the original 25. It is now 100."

How to lie with statistics. "The amount was originally 25, but under the current administration has drastically increased by FOUR HUNDRED PERCENT to its current level of 100."

John