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.

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

Open a new Microsoft Excel 2010 spreadsheet. Click on cell "A1," and enter the first number in the data set you want to get the trimmed mean for. Continue down the first column, and enter ...

It is difficult to calculate these values manually and while calculators make it easier, Excel is the preferred tool for finding these values over a range of cells.

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.