Omega Statistics Blog

Independent Samples t-test in Excel for Summary Data

Mad Scientist Looking at a Beaker

I recently had to run a series of independent samples t-tests on summary data, meaning I only had the group means, standard deviations, and sample sizes. There are online calculators available to do the job.

But my client needed more information on what was going on behind the scenes of the calculations, and I needed a record of what I did. I looked for a way to run summary t-tests in SPSS and even R, and I couldn’t find a way.

So I did what any gal with some stats knowledge and some coding experience would do.

I made this calculator in Excel.

Thanks to Todd Grande for the inspiration. I built my calculator based on his criteria. His video will walk you through it if you’d like to build one of your own. Or, you can just watch his video to see how it works. Enjoy!

Join the Stats for the Masses mailing list to receive the “Stats Grab Bag” email with useful resources and links relating to the work I do each week. I like to think of it as tidbits from practice. You’ll never know what you’ll get, but it could be just what you need!


Thank You - Watch Your Inbox For Our Next News Letter

Accreditations and Memberships

Murrieta Chamber Of Commerce Logo
Better Business Bureau Logo
American Statistical Association