Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change line in Chart | Charts and Charting in Excel | |||
need to make chart w/ confidence intervals and don't know how | Charts and Charting in Excel | |||
need to make chart w/ confidence intervals and don't know how | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |