Hello all,

I am a new comer and am glad to meet you all.

I am a beginner in Excel. I am searching answer on the following problem.

I have some data and I have plotted a trendline using the regression built-in function of excel. There is output data for 95% confidence - both upper and lower. How can I plot the upper and lower confidence bands on the same graph with the trendline? Many thanks.

Gerald

You can easily get the equation of the trendline, and then formulate lines with +- 5% from that line, create the data, then you can plot that line on the same graph easily?

That would be the way I would do it, I'm not very good at using the inbuilt function in excel so maybe someone knows of an easier way to do it

Quote:

---

Originally Posted by gwu

Hello all,

I am a new comer and am glad to meet you all.

I am a beginner in Excel. I am searching answer on the following problem.

I have some data and I have plotted a trendline using the regression built-in function of excel. There is output data for 95% confidence - both upper and lower. How can I plot the upper and lower confidence bands on the same graph with the trendline? Many thanks.

Gerald

---

Every beta weight aka coefficient and intercept, has it's own confidence interval. Use all the upper ones in the calc, and use all the lower ones in the calc. Don't forget the intercept!!