Türk İngilizce
T.DAĞ.2K T.DIST.2T

The T.DIST.2T function in Excel is a statistical function that returns the two-tailed P-value of a t-statistic. This function is most commonly used to determine the likelihood of differences between sample means in small samples. Let’s discuss the syntax and application of this function in more detail.

Syntax and Examples

The syntax for the T.DIST.2T function is as follows:

 T.DIST.2T(x, degrees_freedom) 
  • x – the t-statistic for which you want to calculate the probability.
  • degrees_freedom – the degrees of freedom in the distribution. This must be a positive integer.

Example of usage:

 T.DIST.2T(1.96, 20) 

This example returns the P-value for a t-statistic of 1.96 with 20 degrees of freedom.

Practical Applications

Let us consider a couple of scenarios where this function can be useful.

Task 1: Comparing Means Using a Two-tailed Test

Imagine you need to determine whether there is a significant difference in the average scores of two small classes. Class A has 15 students with an average score of 78 and a standard deviation of 10. Class B has 12 students with an average score of 74 and a standard deviation of 8.

 = T.DIST.2T((78-74)/(SQRT((10^2/15)+(8^2/12))), DEGREES.FREEDOM(15+12-2)) 

In this example, we first calculate the t-statistic based on the mean scores, standard deviations, and sample sizes of the described classes. Then, we use T.DIST.2T to find the two-tailed P-value comparing the means of the two classes.

Task 2: Determining the Significance of Experiment Results

A marketing company conducted an A/B test for two different advertising strategies. 18 people saw Advertisement A, with an average response of 5.6 and a standard deviation of 1.4. For Advertisement B, among 22 people, the average response was 5.1 with a standard deviation of 1.6.

 = T.DIST.2T((5.6-5.1)/(SQRT((1.4^2/18)+(1.6^2/22))), DEGREES.FREEDOM(18+22-2)) 

Here, we analyze whether there is a statistically significant difference between the two advertising strategies, using t-statistics and T.DIST.2T to compute the two-tailed P-value.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/t-dağ-2k-işlevi-198e9340-e360-4230-bd21-f52f22ff5c28

Diğer fonksiyonlar
Bağımsız değişkenler listesinde kaç tane değer bulunduğunu sayar
Bağımsız değişkenler listesinde kaç tane sayı bulunduğunu sayar
Aralıktaki boş hücre sayısını hesaplar
Verilen birden çok ölçüte uyan bir aralık içindeki boş olmayan hücreleri sayar
Verilen ölçütlere uyan bir aralık içindeki boş olmayan hücreleri sayar
İki veri kümesi arasındaki bağlantı katsayısını verir
Doğrusal eğilim boyunca bir değer verir