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

The coefficient of determination is used in statistical analysis to assess how well a model explains and predicts future outcomes. It's more commonly known as r-squared.

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.