9. Testing Differences Between Means: Further Issues

There are several ways to test the likelihood that the difference between two group means is due to chance, and not all of them involve a t-test. Even limiting the scope to a t-test, three general approaches are available to you in Excel:

• The T.DIST() and T.INV() functions

• The T.TEST() function

• The Data Analysis add-in

This chapter illustrates each of these approaches. You’ll want to know about the T.TEST() function because it’s so quick (if not broadly informative). You might decide never to use the T.DIST() and T.INV() functions ...

Get Statistical Analysis: Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.