Question

Find the p-value using Excel (not Appendix D): (Round your answers to 4 decimal places.)

p-value (a) Right-tailed test t = 1.543, d.f. = 10
(b) Two-tailed test t = 2.769, d.f. = 8
(c) Left-tailed test t = –1.934, d.f. = 28

Answer 1

To find the p-value using Excel, you can use the T.DIST.RT and T.DIST functions. For a right-tailed test with a t-value of 1.543 and a degrees of freedom of 10, the p-value is approximately 0.0716.

Step-by-step explanation:

To find the p-value using Excel, you can use the T.DIST.RT function. For a right-tailed test with a t-value of 1.543 and a degrees of freedom of 10, the formula would be =T.DIST.RT(1.543,10). This will give you a p-value of approximately 0.0716. Similarly, for a two-tailed test with a t-value of 2.769 and a degrees of freedom of 8, the formula would be =2*T.DIST.RT(2.769,8). This will give you a p-value of approximately 0.3126. And for a left-tailed test with a t-value of -1.934 and a degrees of freedom of 28, the formula would be =T.DIST(1.934,28).