Trendlines

[travislynk]

I have a scatterplot with two rows of data, A and B. I know how to add a trendline. But, how do I add a 95% upper and lower confidence limit to the graph?

 

[VoG]

This may help http://www.peltiertech.com/Excel/Charts/RunChtLines.html

 

[tusharm]

See
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/publish_train/data_analysis/16.htm
particularly the section 'Confidence Intervals'

I have a scatterplot with two rows of data, A and B. I know how to add a trendline. But, how do I add a 95% upper and lower confidence limit to the graph?