Question: how to test significance of correlation coefficient in excel?
Answer: Calculate the Pearson correlation coefficient in Excel Simply replace 'array1' with the range of cells containing the first variable and replace 'array2' with the range of cells containing the second variable. For the example above, the Pearson correlation coefficient (r) is '0.76'.