Please read the licence information carefully when downloading data.

CorrelationPCalc: A tool for calculating p value of a linear correlation

Description: This Excel spreadsheet will calculate the p-value of a linear correlation, given an N and r. With a little effort (using Excel’s ‘Seek goal’ tool), you can also use it tell you what r value you would need with a given population to get a specific significance level. The spreadsheet uses the fact that sqrt[(1—r2)/(N—2)] is distributed approximately as t with df=N—2.
For more information, see

Citation:  Westbury, C. (2008) CorrelationPCalc: A tool for calculating p value of a linear correlation  Edmonton, AB: University of Alberta (downloaded from

Acknowledgments: This research was supported by NSERC.

If you have any questions about this spreadsheet, please contact Chris Westbury

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 2.5 License.

Download the file:

Please fill out this form so that we can keep track of who has downloaded this file.

Full Name:
Email Address:
What do you intend to use the data for?


©2005, 2006, 2007:w  WestburyLab   chrisw at ualberta dot ca