The test statistic for a two-sample independent t-test is calculated by taking the difference in the two sample means and dividing by either the pooled or unpooled estimated standard error. H a: The population mean of one group is greater than the population mean of the other group, or μ 1 > μ 2 This test can also be conducted with a directional alternate hypothesis: H A: The population mean of one group does not equal the population mean of the other group, or μ 1 ≠ μ 2 H o: The population mean of one group equals the population mean of the other group, or μ 1 = μ 2 For example, we could see if the mean GPA differs between freshman and senior college students by collecting a sample of each group of students and recording their GPAs. Probability associated with a Student's paired t-Test, with a two-tailed distribution.A two-sample independent t-test can be run on sample data from a normally distributed numerical outcome variable to determine if its mean differs across two independent groups. If you need to, you can adjust the column widths to see all the data. For formulas to show results, select them, press F2, and then press Enter. The value returned by T.TEST when tails=2 is double that returned when tails=1 and corresponds to the probability of a higher absolute value of the t-statistic under the “same population means” assumption.Ĭopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If tails=1, T.TEST returns the probability of a higher value of the t-statistic under the assumption that array1 and array2 are samples from populations with the same mean. T.TEST uses the data in array1 and array2 to compute a non-negative t-statistic. If tails is any value other than 1 or 2, T.TEST returns the #NUM! error value. If tails or type is nonnumeric, T.TEST returns the #VALUE! error value. The tails and type arguments are truncated to integers. If array1 and array2 have a different number of data points, and type = 1 (paired), T.TEST returns the #N/A error value. Two-sample unequal variance (heteroscedastic) Two-sample equal variance (homoscedastic)

If tails = 2, T.TEST uses the two-tailed distribution. If tails = 1, T.TEST uses the one-tailed distribution. Specifies the number of distribution tails. The T.TEST function syntax has the following arguments: Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Returns the probability associated with a Student's t-Test.

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel for Mac 2011 Excel Starter 2010 More.

Two sample unequal variance t test