Chart confidence intervals around regression (or trend) line
 

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

Chart confidence intervals around regression (or trend) line
 

See
http://www.stfx.ca/people/bliengme/E...onfidence2.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LeAnne" wrote in message
...
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

Chart confidence intervals around regression (or trend) line
 

OMG! That's brilliant, just brilliant! Thank you SO much!!!

LeAnne

Bernard Liengme saved the day when he wrote:

See
http://www.stfx.ca/people/bliengme/E...onfidence2.htm
best wishes