Statistical Analysis: Microsoft Excel 2016

10Testing 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

Chapter 9, “Testing Differences Between Means: The Basics,” focuses on testing the difference between the mean of an actual sample and a number that you have hypothesized. It’s more likely that you’ll encounter a situation that calls for testing the difference between the means of two samples. This chapter discusses that problem.

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