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


    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


    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.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook