Post Your Answer
7 years ago in Research Methods , Statistical Analysis By Garima Chauhan
Conducting independent t-test using excel.
I want to to conduct independent t-test using excel. My research domain is statistics. How can I conduct the test?
All Answers (3 Answers In All)
By Meghana R Answered 7 years ago
Prepare a data source and calculate sample variance using VAR.S Function.
Step 2: To test variance if the equal or unequal
Firstly, Navigate to Data -> Data Analysis -> F-Test Two-Sample for Variance.
Step 3: To assume two-Sample equal variances
If the tested variances are equal, then select Data analysis t-Test, if not select t-Test: i.e Two-Sample Assuming Unequal Variances.
Reply to Meghana R
By Jyotsnamayee Nayak Answered 7 years ago
Reply to Jyotsnamayee Nayak
By Divya Answered 7 years ago
Reply to Divya
Related Questions