Statistics in Excel
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 |
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 |
All times are GMT +1. The time now is 06:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com