Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
djsquirrel
 
Posts: n/a
Default 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   Report Post  
MrShorty
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i find values on a line graph in Excel? sorrelponie Excel Discussion (Misc queries) 1 September 20th 05 07:35 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 09:03 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 02:09 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 06:19 PM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"