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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

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

Hi Does this work for the Exponential regression as well. If not can you please proive info on how to get it done.

Maxlee