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.

Create a List of Random Numbers with a Seed Value

Random number generation is fairly straightforward in Excel. You can use the RAND or RANDBETWEEN functions to create random numbers but if you wanted to create a pseudo random number from a seed value it would take some VBA or another add on. Not any more, because with Power Query, setting a seed value for repeatable set of random numbers is possible. See the video to learn how.

Add a Random Number in Power Query

If you need to create random numbers in excel it's easy to use the RAND() function for a few numbers, but if you want to create a large amount of random numbers that might be a challenge. So if you wanted half a million or more numbers, think about using Power Query to do this. Also if you have a list of names (500K or more) and you wanted to randomly choose 100, adding a random number to that list and choosing a hundred random names from that list can be done in Power Query. See the video to learn how.