Dahliah2 -

Is there a way to get the confidence interval on the worksheet for t-Test:
Two-Sample Assuming Unequal Variances? <

A method is described on page 132 of my book, Data Analysis Using MS Excel:
Updated for Office XP.

It uses the results from Analysis ToolPak on a worksheet, working
"backwards" from the reported t Stat to get the Standard Error. Use cells
and cell references for the following six quantities:

Observed Mean Difference = Mean2 - Mean1 (using references to cells in the
ToolPak results in the row labeled "Mean")
Standard Error = (Observed Mean Difference - Hypothesized Mean
Difference)/(t Stat)
95% Confidence t =TINV(0.05,df)
Half-Width = (95% Confidence t)*(Standard Error)
Lower Limit = Observed Mean Difference - Half-Width
Upper Limit = Observed Mean Difference + Half-Width

- Mike
www.mikemiddleton.com