Learn how to use the CORREL function and to manually calculate the correlation coefficient (r) in Excel 2010. This allows you to examine is there is a statistical correlation between two variables. Please note: Correlation is NOT causation!