Computing correlation can be time-consuming, but software like Excel makes it easy to calculate.

Negative coefficients indicate opposite direction of movement in most cases. The other key result is the correlation of the two. Regression statistics will typically include an R-squared value.

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.

An Excel pie chart displays categories of data as wedges in a circular graph. This format allows users to quickly see the contribution each category makes to the total figure and a correlation of ...