How To Find The Gradient Of A Graph
 

hi, bascially i jsut need to knwo how to do what my question says. i am
familiar with most things in excel but have never been able to do this and
jsut wondered if it was possible and how to do it basically.

Thankyou In Advance For All Your Help

Kyle

How To Find The Gradient Of A Graph
 

Depends a lot on the specifics of your data set.

1) If your data can be fit to a straight line, you could use a chart
trendline, or the SLOPE or LINEST worksheet functions to obtain the
overall rate of change of the data set.

2) If a straight line won't readily fit your data, then you have
several options, none of which are "built in" type functions. You
could fit your data to a reasonable curve (using a trendline or LINEST
or other technique) and then use calculus to determine the derivative.

Or you could select any two points and estimate the slope by using the
SLOPE function on those two point, or use the formula
slope=(Y2-Y1)/(X2-X1).

Does that help?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=479109