How To Find The Gradient Of A Graph

[djsquirrel]

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

 

[MrShorty]

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 char
trendline, or the SLOPE or LINEST worksheet functions to obtain th
overall rate of change of the data set.

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

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

Does that help