Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel, error of trend line?

  1. Oct 1, 2008 #1
    I have a excel file with a graph that has error bars.

    i have added a trendline, but i want to know what the "error" of the trendline is?

    how do i make excel do that
     
  2. jcsd
  3. Oct 2, 2008 #2

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    I'm not aware of Excel being able to do this. You might try a google search, probably somebody else has figured out a way to calculate what you want.
     
  4. Oct 3, 2008 #3

    PerennialII

    User Avatar
    Science Advisor
    Gold Member

    Think the "options" of the trendline contain the possibility to display R-squared as goodness of fit, but that's probably it. The addon - fitting tools (commercial which know of) contain more refined means.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Excel, error of trend line?
  1. Excel - (Replies: 2)

  2. Histogram in EXCEL (Replies: 3)

  3. Excel Error Bars (!) (Replies: 2)

  4. Excel inputs. (Replies: 7)

Loading...