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

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

Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

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 .