Excel help with error bar formula

[akatsafa]

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.

 

[rattis]

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)

 

[tacman]

Hello,

I understand that you are having trouble creating error bars on Excel for a regression problem. Based on the formula you provided, it seems like you are on the right track. However, there are a few things that could be causing the issue you are experiencing.

First, make sure that your data is organized properly and that you have selected the correct cells for your x and y values. If the data is not in the correct format, it can affect the accuracy of your error bars.

Secondly, double check the values you are using for your intercept and slope (b30 and b31). If these values are incorrect, it can also affect the placement of your error bars.

Lastly, check the cell references for your formula. It's possible that you may have accidentally selected the wrong cells, which could be causing the error bars to appear in the wrong location.

If you have checked these things and are still having trouble, please provide more details about your data and the specific steps you are taking. This will help me better understand the issue and provide a more accurate solution.

I hope this helps and good luck with your regression problem!