Calculate Rate of Change Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Could someone help me w/the rate of chage formula to use when going from a
Negative to a Positive number and visa versa

In the column below - and + #s followinf each other

So what formula should I use to figure out ROC between 1 & 2, then between
2 & 3, then 3 & 4 espicially between 4 & 5, and 8 & 9, when it changes
signs

-0.0021
-0.0007
-0.0009
-0.0004
0.0001
0.0036
0.0028
0.0023
-0.0009

Would have IF and statements?

Because sometime neg follows neg, then neg follows positive, then poistive
follws negative

So what should the formula be?
 
Hi Zee,

If your data is in a1 to a9, in b2 try:

=(A2-A1)/ABS(A1)

copied down to b9, and b2 to b9 formatted as %.

Hope that helps,
Anthony
 
Thanks Anthony & JMB
Below are results,but a Q on them

Result
-0.0021 38
-0.0007 67
-0.0009 -29
-0.0004 56
0.0001 125
0.0036 3500
0.0028 -22
0.0023 -18
-0.0009 -139

Why am I getting +67 between two neg #s, and -29 again between 2 neg #s?
Please help
Thanks
Zee
 
Thanks Anthony & JMB
Below are results,but a Q on them

Result
-0.0021 38
-0.0007 67
-0.0009 -29
-0.0004 56
0.0001 125
0.0036 3500
0.0028 -22
0.0023 -18
-0.0009 -139

Why am I getting +67 between two neg #s, and -29 again between 2 neg
#s?
Click to expand...

because it went from -.0021 to -0.0007 ie increase of 67%
in the other one it drops from -.0007 to -0.0009 ie a drop of 29%

Don't blame the formula if the answers aren't what you expected :)
Seriously, though always good to query the results - it might be a data
error
or one in the formula - always best to check.

You haven't explained what the data is, but as long as the values are
equally spaced in time or whatever
then the results shuold be valid.
 
+67: Because -0.0007 is larger than -0.0021
-29: Because -0.0009 is smaller than -0.0007

Positive rate of change means the numbers are getting larger, negative means
the numbers are getting smaller.
 
If the correct answer for the first 2 numbers is 14, Copy this formula into
the cell to the right of -0.0007 and then fill down. If -0.0021 is not in
(A1) you will need to adjust the formula. ABS doesn't care whether negative
or positive numbers.
=ABS(A1-A2)
 
Back
Top