Excel help with error bar formula

  • Context: Undergrad 
  • Thread starter Thread starter akatsafa
  • Start date Start date
  • Tags Tags
    Error Excel Formula
Click For Summary
SUMMARY

The discussion focuses on creating error bars in Excel for a regression analysis using the formula $b$30+$b$31*$a2+sqrt($d$26). The user is experiencing issues where the error bars do not appear above the regression line as expected. The formula components include intercept and slope values in cells B30 and B31, X values in cell A2, and the mean square residual in D26. An alternative method mentioned involves calculating percentage error and entering it directly into the graph options.

PREREQUISITES
  • Understanding of regression analysis in Excel
  • Familiarity with Excel formula syntax
  • Knowledge of error bar concepts in statistical graphs
  • Experience with Excel graphing tools and options
NEXT STEPS
  • Research how to properly implement error bars in Excel 365
  • Learn about calculating mean square residuals for regression analysis
  • Explore advanced Excel graphing techniques for statistical data
  • Study the impact of line thickness on visual representation of error bars
USEFUL FOR

Data analysts, statisticians, and anyone using Excel for regression analysis who needs to accurately represent error margins in their graphs.

akatsafa
Messages
42
Reaction score
0
I'm trying to create error bars on excel for a regression problem, but something is not working right. I tried following my instructor's directions, but I think something is wrong with them. Here is the formula I added to the formula bar:
$b$30+$b$31*$a2+sqrt($d$26)

b30 and b31 are my intercept + slope, a2 is my x values, and d26 is the MS residual. I should be getting an error bar above my original line, but instead I'm getting the original line. Can someone please tell me what I'm doing wrong?

Thank you.
 
Physics news on Phys.org
Is the error so small that it is no showing up against the thinkness of the line?

I usually calculate the percentage error then enter the value in the options of the graph (right click on trendline, i think)
 

Similar threads

Undergrad Calculating Collection Rate Error in Labs
  • · Replies 31 ·
2
Replies
31
Views
3K
Undergrad Least squares line - understanding formulas
  • · Replies 5 ·
Replies
5
Views
2K
Undergrad Data Plotting Help: Calculating Error Bars for Gradients and Average Gradient
  • · Replies 2 ·
Replies
2
Views
2K
Undergrad Plot Linear Fit w/ Error Bounds: y=ax+b
  • · Replies 3 ·
Replies
3
Views
2K
Graduate Obtaining standard deviation of a linear regression intercep
  • · Replies 3 ·
Replies
3
Views
2K
Graduate Fitting a curve to data with error bars on curve parameters
  • · Replies 10 ·
Replies
10
Views
3K
Graphing Data in Excel: Error Bar Confusion
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Excel projectile trajectory
  • · Replies 6 ·
Replies
6
Views
3K
Graduate Calculating errors and trendline - different correlation coefficients?
  • · Replies 7 ·
Replies
7
Views
4K
Undergrad Combination formula on dice and bit errors
  • · Replies 1 ·
Replies
1
Views
2K