Post Your Answer

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.

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

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.