Tuesday, March 31, 2020

Perform a Two Sample Test in Excel (t-test, equal 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 neat 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