Statistical Analysis: Microsoft Excel 2016 (Byron Wells' Library) by Conrad Carlberg

Statistical Analysis: Microsoft Excel 2016 (Byron Wells' Library) by Conrad Carlberg

Author:Conrad Carlberg
Language: eng
Format: epub
Publisher: Que
Published: 2018-07-15T00:00:00+00:00


Using the T.TEST() Function

The T.TEST() function is a quick way to arrive at the probability of a t-statistic that it calculates for you (but does not display). In that sense, T.TEST() differs from T.DIST(), which requires you to supply your own t-statistic and degrees of freedom; then, T.DIST() returns the associated probability. And T.INV() returns the t-value that’s associated with a given probability and degrees of freedom.

Regardless of the function you want to use, you must always supply the degrees of freedom, either directly in T.DIST() and T.INV() or indirectly, as you’ll see, in T.TEST(). The next section discusses how degrees of freedom in two-group tests differs from degrees of freedom in Chapter 9’s one-group examples, which test the mean of a sample against some hypothetical value.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.