Data Required for T-Value You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom.

With that, Excel can generate a series of random numbers based on the data entered and the standard deviation. With this data you can then create a curved chart, known as a bell curve.