The interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile range -- the central portion of a data set -- is used ...

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.

How to Calculate Depreciation Using Excel. Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, and ...

If you need to find the percentage change in Excel, especially across a range of cells, then this post offers step by step guidance.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

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 .

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.