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:(adsbygoogle = window.adsbygoogle || []).push({});

$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 Forums | Science Articles, Homework Help, Discussion**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel help with error bar formula

**Physics Forums | Science Articles, Homework Help, Discussion**