You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

Multiply the result by 100%, and your portfolio returned a geometric mean of 3.99% over five years, slightly less than the arithmetic mean of (5+3+6+2+4) ÷ 5 = 4.

The variance measures how far each number in the set is from the mean. You can use Microsoft Excel to calculate the variance of the data you have entered into a spreadsheet.