Quantcast excel, error of trend line? Text - Physics Forums Library

PDA

View Full Version : excel, error of trend line?


kchau
Oct1-08, 02:20 AM
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.