Without further context it would be hard to answer, because there are several variants of -test (one sample, for independent samples with equal, or unequal variance, for dependent samples, etc.). Nonetheless, 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 -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.

Answer from Tim on Stack Exchange
🌐
The Bricks
thebricks.com › resources › how-to-find-t-value-in-google-sheets
How to Find the T Value in Google Sheets
The most direct way to run a t-test in Google Sheets is with the T.TEST function. While this function outputs the p-value, not the t-value, it’s the quickest path to getting your answer and an essential first step.
🌐
Google Support
support.google.com › docs › answer › 6055837
T.TEST - Google Docs Editors Help
Returns the probability associated with t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean. Sample Usage T.TEST(A1:A4, B1
🌐
LiveFlow
liveflow.com › product-guides › how-to-run-a-t-test-in-google-sheets
How to Run a T-Test in Google Sheets
Once you have selected the appropriate test, you can close your parenthesis or press enter to run your T-Test. The resulting number is your P-value. ... It is important to know whether you want a one or two-tailed T-Test to be run by your Google Sheets formula.
🌐
Google Support
support.google.com › docs › thread › 203961098 › t-test-statistic-formula-help-t-statistic
t-test Statistic Formula Help (t-statistic) - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Privacy Policy · Terms of Service · Submit feedback · Send feedback on... This help content & information · General Help Center experience ·
🌐
Statology
statology.org › home › how to perform t-tests in google sheets
How to Perform t-Tests in Google Sheets
October 6, 2020 - This tutorial explains how to perform t-tests in Google Sheets, including several examples.
Find elsewhere
🌐
Quora
quora.com › How-do-I-do-a-t-test-in-Google-Sheets
How to do a t-test in Google Sheets - Quora
Answer: Use the Google Sheets function T.TEST. This function is documented in Google Sheets Help: [code ]T.TEST(range1, range2, tails, type)[/code] * [code ]range1[/code] - The first sample of data or group of cells to consider for the t-test.
🌐
Coefficient
coefficient.io › home › how to calculate p-value in google sheets: a comprehensive step-by-step guide
How to Calculate P-Value in Google Sheets: A Comprehensive Step-by-Step Guide
September 2, 2025 - Choose a cell for your p-value calculation. Enter the T.TEST function: Copy =T.TEST(A2:A21, B2:B21, 2, 2) This assumes: ... Press Enter: Google Sheets will calculate the p-value.
🌐
YouTube
youtube.com › watch
How to do a t test in Google Sheets - YouTube
AboutPressCopyrightContact usCreatorsAdvertiseDevelopersTermsPrivacyPolicy & SafetyHow YouTube worksTest new featuresNFL Sunday Ticket
Published   February 11, 2015
🌐
The Bricks
thebricks.com › resources › how-to-use-t-test-in-google-sheets-a-step-by-step-guide
How to Use T.TEST in Google Sheets: A Step-by-Step Guide
The T.TEST function in Google Sheets doesn't give you a simple "yes" or "no" answer. Instead, it gives you a p-value.
🌐
Statology
statology.org › home › how to calculate critical values in google sheets
How to Calculate Critical Values in Google Sheets
April 27, 2021 - This tutorial explains how to calculate critical values in Google Sheets, including several examples.
🌐
Google Sheets
sheetsformarketers.com › home › blog › how to do a t test in google sheets
How To Do A T Test In Google Sheets in 2025 (+ Examples)
November 1, 2023 - A T-Test is a good way to do this, and fortunately Google Sheets has a built-in T-Test function that makes it easy to perform T-Tests on samples stored in your spreadsheet.
🌐
YouTube
youtube.com › watch
1 Sample T Test in Google Sheets | P-Value, Test and Critical t for T Test - YouTube
Easily run a 1 sample t test in Google Sheets with a data set. We will compute the test t statistic, critical t value, and p-value for a t-test of the mean ...
Published   May 16, 2023
🌐
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › how to do a t-test in google sheets [simple guide]
How to Do a T-Test in Google Sheets [Simple Guide] | SSP
July 17, 2022 - Here are the steps you need to follow on how to perform T-Test in Google Sheets: Step 1: Click on the cell where you wish to put the formula and type in the starting part of the formula.
🌐
Checksheet
checksheet.app › google-sheets-formulas › tinv
TINV Google Sheets Formula | Check Sheet
The TINV function can be used to calculate p-values for t-tests. For example, if you have a t-statistic of 2.5 with 10 degrees of freedom, you could use =TINV(0.05, 10) to find the critical value and then use the TDIST function to calculate ...
🌐
Causal
causal.app › formulae › t-test-google-sheets-e
T.TEST: Google Sheets Formulae Explained
Assume that we have the test scores of both groups in two columns of our Google Sheets document. We can apply the T.TEST function as follows: ... In this example, A2:A11 and B2:B11 are the ranges for the two groups of students. The number 2 indicates that we're using a two-tailed distribution, and the number 3 indicates that we're performing a two-sample unequal variance t-test. The function will return a p-value.
🌐
The Bricks
thebricks.com › resources › how-to-use-t-inv-2t-in-google-sheets-a-step-by-step-guide
How to Use T.INV.2T in Google Sheets: A Step-by-Step Guide
Step 2: Type the formula =T.INV.2T(probability, degrees_freedom) replacing probability with your chosen significance level (e.g., 0.05) and degrees_freedom with the calculated value from the previous section.