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.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

How to Calculate Variance in Excel To calculate variance in Excel, you will need to have your data set already entered into the software. Once you have your data, you can choose your formula based ...