Chart confidence intervals around regression (or trend) line

  • Thread starter Thread starter LeAnne
  • Start date Start date
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
 
OMG! That's brilliant, just brilliant! Thank you SO much!!!

LeAnne
 
You must log in or register to reply here.

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
best straight line in Excel 3
how to produce horizontal line chart of point est & 95% ci's 2
Widening charts and adding vertical lines 1
Trend line in Excel 3

Back
Top