View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default 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