Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find values on a line graph in Excel? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |