Statistical Analysis with Excel For Dummies
Book image
Explore Book Buy On Amazon
Visualizing a distribution often helps you understand it. It’s easy with Excel, and it’s instructive. The image below shows how to do it for a t-distribution. The function you use is T.DIST, with the FALSE option in the Cumulative box.

Visualizing a t-distribution.

Here are the steps:

  1. Put the degrees of freedom in a cell. For this example, put 15 into cell C2.
  2. Create a column of values for the statistic. In cells D2 through D42, put in the values –4 to 4 in increments of .2.
  3. In the first cell of the adjoining column, put the value of the probability density for the first value of the statistic. Because you’re graphing a t-distribution, you use T.DIST in cell E2. For the value of X, you click cell D2. For df, you click C2 and press the F4 key to anchor this selection. In the Cumulative box, type FALSE to return the height of the distribution for this value of t. Then click OK.
  4. Autofill the column with the values.
  5. Create the chart. Highlight both columns. On the Insert tab, in the Charts area, select Scatter with Smooth Lines.
  6. Modify the chart. The chart appears with the y-axis down the middle. Click on the x-axis to open the Format Axis panel. Under Axis Options, in the Vertical Axis Crosses area, click the radio button next to Axis Value and type -5 into the box. You can then click inside the chart to make the Chart Elements tool (the plus sign) appear and use it to add the axis titles (t and f(t)). You can also delete the chart title and the gridlines if you like to stretch out the chart.
  7. Manipulate the chart. To help you get a feel for the distribution, try different values for df and see how the changes affect the chart.

About This Article

This article is from the book:

About the book author:

Joseph Schmuller works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of Statistical Analysis with Excel For Dummies.

This article can be found in the category: