Product Moment Correlation Coefficient

Rate this resource

This series of interactive excel sheets explore the product moment correlation coefficient (PMCC). Another title can be found in our Virtual Textbook: Secondary collection.

The first sheet generates a set of bi-variate data and plots them on a scatter graph to enable discussion. A new set of data can be generated, and the region that the value of the PMCC to lies within can be specified.

The next sheets demonstrate two methods of calculating Sxx, Syy, Sxy and the PMCC. A new set of data can be produced, and values can be revealed one at a time. The scatter graphs for the data sets can be seen on subsequent pages.

The fourth sheet contains a summary of the formulae to calculate the PMCC.

The next sheet generates a table of five sets of data from which students can calculate Sxx, Syy, Sxy and the PMCC. Answers are included.

This program was designed by be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on users’ machine.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Show downloads

Published by


Share this resource