The values assigned to the correlation coefficients range from -1.0 and 1.0. A “perfect” positive correlation of +1.0 would mean that two variables move exactly in lockstep with one another ...

Following is the syntax for the CORREL function in Excel: =CORREL(array1, array2) Array1 and array2 are the two ranges of data you want to analyze. A correlation coefficient 1 would mean a perfect ...