T Test Formula Excel. Returns the probability associated with a student s t test. The t test is used to test the null hypothesis that the means of two populations are equal.
Returns the probability associated with a student s t test. It is the first data set. If array1 and array2 have a different number of data points and type 1 paired t test returns the n a error value.
If tails 1 t test uses the one tailed distribution.
If tails or type is nonnumeric t test returns the value. μ 1 μ 2 0. It is the first data set. This article describes the formula syntax and usage of the ttest function in microsoft excel.