SheetFX
≡
<< Go back to all functions

T.TEST

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.

Function Syntax and Parameters

Syntax: T.TEST(range1, range2, tails, type)

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

  1. Using T.TEST for two-tailed paired test:

    • Example: =T.TEST(A1:A10, B1:B10, 2, 1)
    • Result: The probability associated with the two-tailed paired t-test.

  2. Using T.TEST for one-tailed unpaired test:

    • Example: =T.TEST(A1:A10, B1:B10, 1, 2)
    • Result: The probability associated with the one-tailed unpaired t-test.

Use Cases and Scenarios

  1. Hypothesis Testing: Determine if there is a significant difference between two sets of data.
  2. Medical Research: Compare the effectiveness of two treatments on patient outcomes.
  3. 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.

Related Articles