View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default Statistics in Excel

Use the FTEST worksheet function or "F-Test Two-Sample for Variances" to test
for equality of variances. Help for the FTEST worksheet function is wrong;
it is a two-tailed test for inequality in either direction.

There is also a 3rd t-test in the Anlysis ToolPak (ATP): the paired t-test.

The 3 t-tests in the ATP are equivalent to the 3 types in the TTEST
worksheet function.

Jerry

"rakbhat" wrote:

In the Data Analysis add in there's two t-tests: one for samples with equal
variance and one with unequal variance- how do you test to see if the
variances are equal or unequal using excel and therefore choose the right
t-test?
Thanks for your help.
--
rakbhat