In finance, correlation is used in several facets of analysis including the calculation of portfolio standard deviation. Computing correlation can be time-consuming, but software like Excel makes ...

The correlation function will ask for two rows of data from two identical timeframes. Input, click ok and voila—correlation coefficient. The correlation coefficient is a number between 1 and -1.