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

Click For Summary
The discussion centers on calculating the error of a trendline in Excel, specifically in relation to a graph with error bars. Users express uncertainty about Excel's capabilities to directly provide this information. While it is noted that Excel can display the R-squared value as a measure of goodness of fit for the trendline, there is a consensus that Excel lacks built-in features for calculating trendline error. Suggestions include searching online for potential solutions and considering commercial add-ons like fitting tools that offer more advanced statistical analysis options.
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.
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
Replies
2
Views
3K
  • · Replies 17 ·
Replies
17
Views
4K