Leslie Kramer is a writer for Institutional Investor, correspondent for CNBC, journalist for Investopedia, and managing editor for Markets Group. Correlation measures the linear relationship ...

They could have a low correlation if the return is monthly changes over the past 52 weeks. Which is better? It depends on the purpose of the test. You can calculate R-squared in Excel using ...

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 correlation which is defined by a ...

This is a convenient way to calculate a correlation between just two data sets. But what if you want to create a correlation matrix across a range of data sets? To do this, you need to use Excel's ...