How to compare averages with different sample sizes in excel

1. How do you compare two averages with different sample sizes?
2. When comparing two samples of different sizes in Excel?
3. Can you do at test with unequal sample sizes Excel?
4. Can you do at test with two different sample sizes?

How do you compare two averages with different sample sizes?

One way to compare the two different size data sets is to divide the large set into an N number of equal size sets. The comparison can be based on absolute sum of of difference. THis will measure how many sets from the Nset are in close match with the single 4 sample set.

When comparing two samples of different sizes in Excel?

If you're comparing two samples and their sample sizes are different, and regardless of whether they're different or the same, you would want to use a T. Test.

Can you do at test with unequal sample sizes Excel?

Sample sizes between groups do not have to be equal. The test statistic is a student�s t-test with N‑2 degrees of freedom, where N is the total number of subjects.

Can you do at test with two different sample sizes?

Yes, you can perform a t-test when the sample sizes are not equal. Equal sample sizes is not one of the assumptions made in a t-test. The real issues arise when the two samples do not have equal variances, which is one of the assumptions made in a t-test.