Calculate correlation coefficient in Excel
For linear correlations you can install the data analysis toolpak by going to options -> add-ins -> hit u2018gou2019 at the bottom -> check the analysis toolpak and hit ok -> now navigate to your data tab and select data analysis on the top right -> lastly select correlation and specify your data.
,That will leverage built-in excel functionality to calculate your coefficients which I assume is what youu2019re looking for since you specified Excel.
Otherwise the formula is pretty easy to reproduce with basic excel in-line functions and can be found with a quick google search.
How to find Pearsons correlation coefficient on calculator
Start by converting both of your variables to z scores.
(Z = X - Mean of X),next, multiply the z scores for each pair of scores together.
(Zx*Zy),third, add together all the z products (sum of all Zx*Zy),Last, divide by the number of pairs.
Calculate correlation coefficient in R
Given data is insufficient to compute correlation.
,The values of u03a3X and u03a3Y are also required to compute r.