Pearson correlation is a test to determine the degree of correlation (association) between two variables.
The requirements of the test are:
Data in existing Excel worksheets can be used and should be arranged in a List dataset layout. The dataset must contain two continuous scale variables.
When entering new data we recommend using New Dataset to create a new 2 variables dataset ready for data entry.
To start the test:
Excel 97, 2000, 2002 & 2003:
Select any cell in the range containing the dataset to analyse, then click Analyse on the Analyse-it toolbar, click Correlation then click Pearson.
The report shows the number of observations analysed, and, if applicable, how many missing cases were pairwise deleted.
The Pearson r correlation statistic and confidence interval are shown.
METHOD The confidence interval is calculated using the Fisher's Normal transformation (see  or ).
The hypothesis test is shown. The p-value is the probability of rejecting the null hypothesis, that the variables are independent, when it is in fact true. A significant p-value implies that the two variables are correlated.
METHOD The p-value is calculated using the t approximation (see ).
The scatter plot (see below) shows a visual assessment of the strength of association.
We've been developing intuitive high-quality statistical software at an affordable price, backed up by fast friendly customer service for over 25 years...
Office hours: 9am-5pm GMT Mon-Fri
It's Tuesday 5:02 PM and the office is closed - e-mail us and we'll get back to you as soon as possible.