Excel help with error bar formula

  • Thread starter akatsafa
  • Start date
  • #1
42
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.
 

Answers and Replies

  • #2
41
0
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)
 

Related Threads on Excel help with error bar formula

Replies
11
Views
10K
Replies
3
Views
4K
  • Last Post
Replies
6
Views
3K
Replies
11
Views
9K
  • Last Post
Replies
7
Views
9K
  • Last Post
Replies
1
Views
2K
Replies
10
Views
2K
Replies
1
Views
1K
Replies
1
Views
767
Top