Statistical Analysis: Microsoft® Excel 2010, Video Enhanced Edition

9. Testing Differences Between Means: Further Issues

IN THIS CHAPTER

Using Excel’s T.DIST() and T.INV() Functions to Test Hypotheses 225

Using the T.TEST() Function 236

Using the Data Analysis Add-in t-Tests 251

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