Tuesday, March 17, 2020

Perform a Two Sample Test in Excel (t-test, unequal variances)



When you're trying to compare two population samples to see if the difference is significant or based on random chance, you're likely to perform a t-test for your hypothesis testing. Another thing to think about is to determine if it is a equal or unequal variance t-test. Excel provide an excel-lent feature in the Data Analysis Toolpak to do this easily and I'll cover it, but also show how to use the formulas to manually figure it out.

No comments:

Post a Comment