T-Test – Where to Find T Statistic and Degrees of Freedom in Google Sheets?

degrees of freedomt-test

I'm using Google sheets to find TTEST scores. Its outcome is a single value, namely, p value. But in addition to this p value I also need to report degree of freedom and a t statistic value:
t(degress of freedom) = the t statistic, p = p value.

Example T Test report on apa stlye:
"The 25 participants who received the drug intervention (M = 480, SD = 34.5) compared to the 28 participants in the control group (M = 425, SD = 31) demonstrated significantly better peak flow scores, t(51) = 2.1, p = .04."
From https://www.socscistatistics.com/tutorials/ttest/default.aspx#:~:text=The%20basic%20format%20for%20reporting,of%20t%2Dtest%20was%20used.

Where or how can I find these two values (t statistic and degree of freedom)? I appreciate your help.

Best Answer

Without further context it would be hard to answer, because there are several variants of $t$-test (one sample, for independent samples with equal, or unequal variance, for dependent samples, etc.). Nonetheless, $t$ statistic and degrees of freedom are defined in terms of things like mean, standard deviation, and number of samples for both groups, where the formulas for calculating them can be found in statistics handbooks, and many places on web, including Wikipedia. I'd recommend you find the appropriate variant of the $t$-test that you are using (are you sure that the spreadsheet calculates the correct one for you?) in Wikipedia's article and calculate it by hand, you need nothing more then the pocket calculator for this.

Related Question