The number to pay attention to in linear regression is the correlation coefficient. In the resulting table, it's listed as "r2" since it's the square of the correlation coefficient.

When making large, frequent bets, calculate optimal position sizing if you can, based on the expected payout and your estimate of the correlation between past/expected returns and future returns.

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 .

Calculating the Pearson correlation coefficient can be complicated but software makes it much easier. You can use several methods to calculate correlation in Excel.

Correlation vs Regression: Both correlation and regression are two powerful tools of statistics and data analysis used to understand the relationships between variables.

Regression analysis is a statistical technique used to find relationships between independent and dependent variables. Regression analysis uses historical data and observation to predict future ...

A quantitative study is made of the bias in the usual estimate of the linear correlation coefficient and of the relative efficiency of the estimated regression, when a certain type of selective ...

Understanding one of the most important types of data analysis.