Computing the Correlation in EXCEL
Follow this link for free tutorials on Excel.
Pearson's correlation is a measure of the relationship between two variables. In EXCEL, you compute it by first selecting the cell in which you want the correlation to appear.![selecting the cell](graphics/correlation_begin.jpg)
Next you choose Insert/Function from the menu bar.
![insert function](graphics/insert_function.jpg)
Double click on CORREL from the list. It is in the category "Statistical." The functions are arranged by category with the categories listed in alphabetical order.
![insert function](graphics/correlation_insert_function.jpg)
Select the first range of values on the worksheet or enter the range in the field "array 1" in the formula builder.
![selecting range 1](graphics/correl_range1.jpg)
Click in the field for "array2" and specify the range.
![selecting rrange 2](graphics/correl_range2.jpg)
Hit "Enter" or "Return" to confirm the selection and the correlation will be computed.
![result](graphics/correlation_result.jpg)