Calculate Rate of Change Formula

Z

Zee

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?
 
A

Anthony D

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
 
Z

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?
Please help
Thanks
Zee
 
S

SteveW

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.
 
J

JMB

+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.
 
R

Rookie 1st class

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)
 
Top