This article illustrates how to make a t-distribution graph in excel. Distribution in statistics deals with the relationships between observations and their probabilities. There are various types of distributions in statistics. The t-distribution, also known as the studentâ€™s t-distribution, is similar to the **normal distribution** except with heavier tails. There is a greater possibility for a few students in a classroom to make very high or low scores. The t-distribution is used in such a scenario. Follow this article to make a t-distribution graph in excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from the download button below.

## What Is t-Distribution?

Distribution in statistics deals with the relationships between observations and their probabilities. There are various types of distributions in statistics. The t-distribution, also known as the studentâ€™s t-distribution, is similar to the normal distribution except with heavier tails. It is usually used for hypothesis testing of small sample datasets. There is a greater possibility for a few students in a classroom to make very high or low scores. Thet-distribution is used in such a scenario.

## Steps to Make a t-Distribution Graph in Excel

Follow the steps below to create a t-distribution graph in excel.

### đź“Ś Step 1: Organize Data

- You need to organize your dataset properly to make a proper t-distribution graph in excel. Here we will create a dataset for the purpose of illustration.
- At first, enter
**4**and**5**in cells**B5**and**B6**respectively. Then select those cells.

- Now drag the
**Fill Handle**icon to cell**B21**. After that, you will get the following result.

### đź“Ś Step 2: Generate t-Distribution

- Next, enter the following formula in cell
**C5**. Then, drag the**Fill Handle**icon to cell**C21**. After that, you will see the following result. Here the**T.DIST function**returns the left-tailed t-distribution.

`=T.DIST(B5,30,FALSE)`

### đź“Ś Step 3: Insert t-Distribution Graph

- Now select the range
**C5:C21**. Then choose**Insert Scatter (X, Y) or Bubble Chart >> Scatter >> Scatter with Smooth Lines**from the**Insert**tab.

- After that, you will get the following result.

### đź“Ś Step 4: Edit Chart Title

- Now click on the
**Chart Title**to rename it as required.

### đź“Ś Step 5: Change Chart Type

- Next, right-click on the chart and click on
**Change Chart Type**.

- Then choose the
**Clustered Column**chart type and click OK.

- After that, you will get the following result.

**Read More:** **How to Create a Distribution Chart in Excel (2 Handy Methods)**

### đź“Ś Step 6: Finalize t-Distribution Graph

- Now click on the graph to access the
**Format**Then click on**Curve**in the**Insert Shapes**group.

- Next, click on the top of all columns to create a smooth curve and press
**Enter**at the end. After that, the final graph will look as follows.

**Read More:** **Plot Normal Distribution in Excel with Mean and Standard Deviation**

## Things to Remember

- The t-distribution should be used for a smaller number (<30) of sample datasets with unknown standard deviation.
- You should use the normal distribution instead for accuracy in case of larger datasets and known standard deviations.

## Conclusion

Now you know how to make a t-distribution graph in excel. Do you have any further queries or suggestions? Please let us know using the comment section below. You can also visit our **ExcelDemy** blog to explore more about excel. Stay with us and keep learning.