|May 26th, 2010, 08:09 AM||#1|
Joined: May 2010
Calculating positive percentage change
Hi there, I am trying to calculate the positive change between monthly values.
Lets say I have the following values:
Month 1) -25,300
Month 2) -18,900
Month 3) -8,200
Month 4) -1,300
Month 5) 1,100
Month 6) 4,200
I want to see what the change is every month as a positive percentage. For the positive numbers, I can calculate say for month 6, the difference was (month6-month5)/month5. Is there a formula to always give me a positive change regardless of whether the inputs are negative or positive?
|May 26th, 2010, 01:42 PM||#2|
Joined: Apr 2010
Re: Calculating positive percentage change
I think if you have a number of months m1, m2, m3......m(n)....
to find the positive percent gain from some month m(n) to the next month m(n+1), I thnk the equation is
[m(n+1) - m(n)] / |m(n)|. Notice that the denominator is in absoulte value brackets. This way, it doesn't matter if any of the terms are negative...you will always get a positive result as long as money keeps going up every month.
|February 9th, 2017, 07:14 AM||#5|
Joined: Jan 2015
The "percentage change" is always the amount of change divided by the absolute value of the original amount. Here, on the first month, the amount was -25300. On month 2, the amount was -18900, an increase of -18900- (-25300)= 6400. so the percentage increase is 25.3%.
|calculating, change, percentage, positive|
|Search tags for this page|
Click on a term to search for related topics.
|Thread||Thread Starter||Forum||Replies||Last Post|
|0 is POSITIVE||josellie1234||Number Theory||10||August 20th, 2013 09:28 AM|
|Enquiry on Calculating number of factors of positive integer||rnck||Advanced Statistics||4||June 13th, 2013 08:19 AM|
|Need help with calculating percentage||chillies||Elementary Math||3||February 12th, 2012 07:38 PM|
|formula for calculating an changing percentage||Leander||Applied Math||0||February 3rd, 2012 02:04 PM|
|positive definite||wannabe1||Linear Algebra||1||April 26th, 2010 07:00 AM|