In cells D2 through D42, put in the values 4 to 4 in increments of.2.

Because youre 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.

On the Insert tab, in the Charts area, select Scatter with Smooth Lines.

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.

To help you get a feel for the distribution, try different values for df and see how the changes affect the chart.

He is a former member of the American Statistical Association and has taught statistics at the undergraduate, honors undergraduate, and graduate levels.

How To Run A T-Test In Excel For Mac