+ Reply to Thread
Results 1 to 2 of 2

How To Find The Gradient Of A Graph

  1. #1
    djsquirrel
    Guest

    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. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,813
    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1