Question

Which Excel statement will approximate the p-value for the t statistic in a left-tailed test with t = 2.15 and 20 df?

a. =T.DIST.T(2.15,20)
b. =T.DIST.RT(2.15,20)
c. =T.DIST.LT(2.15,20)
d. =T.DIST.2T(2.15,20)
e. =T.DIST(2.15,20, TRUE)

Answer 1

The correct Excel statement for approximating the p-value in a left-tailed test with t = 2.15 and 20 df is '=T.DIST(2.15,20,TRUE)' option e is correct.

Step-by-step explanation:

The Excel statement that will approximate the p-value for the t-statistic in a left-tailed test with t = 2.15 and 20 degrees of freedom (df) is =T.DIST(2.15,20,TRUE).

This formula calculates the cumulative distribution function for a t-distribution, which is what you need for a left-tailed test to find the p-value.

Other functions like =T.DIST.2T and =T.DIST.RT are used for two-tailed tests and right-tailed tests, respectively, hence they are not applicable here.

The Excel statement that will approximate the p-value for the t statistic in a left-tailed test with t = 2.15 and 20 df is =T.DIST.T(2.15, 20). This function calculates the cumulative probability for a given t-value and degrees of freedom.