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

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

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

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.