Calculate your T-Value by taking the difference between the mean and population mean and dividing it over the standard deviation divided by the degrees of freedom square root.

If you are looking forward towards calculating the Standard Deviation and Standard Error of the Mean in Excel, please check this article.

How to Calculate a Trimmed Mean in Excel. A trimmed mean is much like a standard mean, which you can derive in Excel using the AVERAGE function. However, instead of using all of the data points to ...