PHD Discussions Logo

Ask, Learn and Accelerate in your PhD Research

Question Icon Post Your Answer

Question Icon

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

Step 1: To calculate the sample variance
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.

By Jyotsnamayee Nayak Answered 7 years ago

To learn in-depth checkout https://www.youtube.com/watch?v=norKDF0MH0M.

By Divya Answered 7 years ago

It is better to seek assistance from statisticians to conduct data analysis rather than trying on your own. My friend availed help from https://www.chanakya-research.com/. You can give a second thought about it.

Your Answer