Chart confidence intervals around regression (or trend) line

L

LeAnne

Okay, it seems like this should be simple, but I can't figure it
out...how can I develop (and chart) 95% confidence interval lines around
a trend line in a regression scatter plot? The regression summary output
table includes values for the lower and upper 95%, but I can't figure
out how to make use of this information. And the stuff in Help on the
CONFIDENCE() function is no help at all.

XL97, WIN XP.

tia,

LeAnne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Regression in Analysis Tool Pack - Confidence Intervals 1
linear trend lines 2
Excel 2002 Analysis ToolPak Regression Analysis Help Requested 1
Problem with Regression function in 2007, Analysis Tool Pak 2
Trend line in Excel 3
how to produce horizontal line chart of point est & 95% ci's 2
plotting confidence bands 3
Excel 2003 F9 wierdness 1

Top