For example, if your mean is in cell A2, population mean in cell B2, standard deviation in cell C2, square root of degrees of freedom in E2, type the formula as =(A2-B2)/(C2/E2) to generate the T ...

Find each data point's difference from the mean value. Square each of these values. Add up all of the squared values. Divide this sum of squares by n – 1 (for a sample) or N ...