Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Confidence intervals for each individual sample in excel?
Hi, I'm trying to obtain both the least square estimates, and interval
estimates for EACH individual sample (in table format). Not the overall regression analysis for all samples combined. Any help would be greatly appreciated. Thank you, Catherine |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Confidence intervals for each individual sample in excel?
Catherine -
If by "individual sample" you mean "individual observation" or individual data point, then these formulas from Jerry W. Lewis in 2003 may be useful: The confidence bound for the estimated line at x is =FORECAST(x,known_y's,known_x's) +/- TINV((1-conf)*2,COUNT(known_y's)-2) *STEYX(known_y's,known_x's) *SQRT(1/COUNT(known_y's)+(x-AVERAGE(known_x's))^2/DEVSQ(known_x's)) The confidence bound for an individual observation at x is =FORECAST(x,known_y's,known_x's) +/- TINV((1-conf)*2,COUNT(known_y's)-2) *STEYX(known_y's,known_x's) *SQRT(1+1/COUNT(known_y's)+(x-AVERAGE(known_x's))^2/DEVSQ(known_x's)) - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Catherine" wrote in message ... Hi, I'm trying to obtain both the least square estimates, and interval estimates for EACH individual sample (in table format). Not the overall regression analysis for all samples combined. Any help would be greatly appreciated. Thank you, Catherine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sample Size and Confidence Interval | Excel Discussion (Misc queries) | |||
Will excel generate one-tailed confidence intervals for Poisson distribution? | Excel Worksheet Functions | |||
Confidence Intervals | Excel Discussion (Misc queries) | |||
How do I do a chart with overlaying confidence intervals? | Charts and Charting in Excel | |||
need to make chart w/ confidence intervals and don't know how | Charts and Charting in Excel |