 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-25-2005, 11:05 AM
|
|||
|
|||
|
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
10-25-2005, 02:59 PM
|
|||
|
|||
|
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?
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
