# T-Distributions with Excel Formulas

Please help with the following problem.

For a t distribution with 16 degrees of freedom, find the area, or probability, in each region.

a.) To the right of 2.120. (Use 3 decimals.) __________

b.) To the left of 1.337. (Use 2 decimals.) __________

c.) To the left of -1.746. (Use 2 decimals.) __________

d.) To the right of 2.583. (Use 2 decimals.) __________

e.) Between -2.120 and 2.120. (Use 2 decimals.) __________

f.) Between -1.746 and 1.746. (Use 2 decimals.) __________.

© BrainMass Inc. brainmass.com October 2, 2020, 2:56 am ad1c9bdddfhttps://brainmass.com/statistics/probability/tdistributions-excel-formulas-465664

#### Solution Preview

Please see the attached Excel file to see the solutions provided below in Excel format.

Problem: For a t distribution with 16 degrees of freedom, find the area, or probability, in each region.

a. To the right of 2.120. (Use 3 decimals.) __________

b. To the left of 1.337. (Use 2 decimals.) __________

c. To the left of -1.746. (Use 2 decimals.) ...

#### Solution Summary

This solution helps find probability (or the area of an area) of t-distributions. Step-by-step calculations are given. The formulas and calculations are also given in Excel format.