Statistics in Excel

R

rakbhat

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.
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top