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 ...