The T.TEST function in Google Sheets is a statistical tool used to determine the probability associated with Student's t-test. It helps in identifying whether two samples are likely to have come from the same two underlying populations that have the same mean.
Parameters
range1: The first range of data.range2: The second range of data.tails: The number of distribution tails to consider (1 for a one-tailed test, 2 for a two-tailed test).type: [Optional] The type of t-test to perform (1 for paired, 2 for unpaired).
Step-by-Step Tutorial
-
Using
T.TESTfor two-tailed paired test:- Example:
=T.TEST(A1:A10, B1:B10, 2, 1) - Result: The probability associated with the two-tailed paired t-test.
- Example:
-
Using
T.TESTfor one-tailed unpaired test:- Example:
=T.TEST(A1:A10, B1:B10, 1, 2) - Result: The probability associated with the one-tailed unpaired t-test.
- Example:
Use Cases and Scenarios
- Hypothesis Testing: Determine if there is a significant difference between two sets of data.
- Medical Research: Compare the effectiveness of two treatments on patient outcomes.
- A/B Testing: Analyze the impact of changes made to a website by comparing user engagement metrics.
Related Functions
T: Returns the Student's t-distribution.HYPGEOM.DIST: Calculates the hypergeometric distribution.