LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
LeAnne
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change line in Chart JeroenM Charts and Charting in Excel 4 October 26th 05 08:07 AM
need to make chart w/ confidence intervals and don't know how penguinchick Charts and Charting in Excel 2 September 21st 05 02:57 PM
need to make chart w/ confidence intervals and don't know how penguinchick Charts and Charting in Excel 0 September 20th 05 06:41 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"