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
Redbelly98
Oct2-08, 09:11 AM
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.
PerennialII
Oct3-08, 04:21 AM
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.