How to Do Residuals in Excel. Linear regression models predict the outcome of one variable based on the value of another, correlated variable. Excel 2013 can compare this data to determine the ...

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 graph linear regression in Excel. Use these steps to analyze the linear relationship between an independent and a dependent variable.

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