Statistical Analysis: Microsoft® Excel® 2013

9. Testing Differences Between Means: Further Issues

In This Chapter

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

Using the T.TEST() Function

Using the Data Analysis Add-in t-Tests

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