Results 1 to 4 of 4

Math Help - Using excel to calculate gradient

  1. #1
    Senior Member
    Joined
    Jul 2008
    Posts
    313

    Using excel to calculate gradient

    After plotting the graph using excell, does anyone know how to use excell to find the gradient and include it on the graph?

    Thanks
    Follow Math Help Forum on Facebook and Google+

  2. #2
    A Plied Mathematician
    Joined
    Jun 2010
    From
    CT, USA
    Posts
    6,318
    Thanks
    4
    Awards
    2

    re: Using excel to calculate gradient

    What are you plotting? Is it an xy scatter plot to which you are fitting a straight line?
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Senior Member
    Joined
    Jul 2008
    Posts
    313

    Re: Using excel to calculate gradient

    Quote Originally Posted by Ackbeet View Post
    What are you plotting? Is it an xy scatter plot to which you are fitting a straight line?
    I have produced the graph using the xy scatter yes, however I have also manually drawn the graph and the computer has drawn the straight line through the origin at '0', which is wrong, the graph should be at x = (-4, -2) (2, 7), I have used the equation to calculate the results also and know the manual drawn graph is correct.

    So I am thinking now of forgetting the computer excell software programme, which I think is the wrong design for producing graphs with up to four quadrants.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    -1
    e^(i*pi)'s Avatar
    Joined
    Feb 2009
    From
    West Midlands, England
    Posts
    3,053
    Thanks
    1

    Re: Using excel to calculate gradient

    Add trendline iirc.

    You can show the equation on it and the r^2 value to see how accurate it is. I've found that excel tries to include outliers too.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 0
    Last Post: January 15th 2012, 01:32 PM
  2. Calculate Gradient
    Posted in the Calculus Forum
    Replies: 6
    Last Post: January 15th 2010, 01:50 AM
  3. excel
    Posted in the Math Software Forum
    Replies: 8
    Last Post: April 23rd 2008, 07:48 AM
  4. excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: January 21st 2008, 05:24 AM
  5. Excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: August 13th 2007, 05:26 PM

Search Tags


/mathhelpforum @mathhelpforum