What is the error of the trendline in Excel with error bars?

Join the discussion
Registration is free. Start your own thread to ask a follow-up.
2 replies · 14K views
kchau
Messages
5
Reaction score
0
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
 
Physics news on Phys.org
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.
 
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.