A scatter diagram is a graph that helps you visualize the relationship between two variables. It is used to check if changes in one variable are associated with changes in the other variable. For example, a scatter diagram can be plotted to check if there is a relationship between the number of months a person has been on the job and the time it takes him or her to complete his or her duties.
This template allows you to enter the two sets of data and the scatter diagram will be displayed automatically. In addition to displaying the scatter diagram, it also tests the correlation between the two data sets using Pearson’s coefficient correlation test. Care should be taken, however, that this testing for correlation does not imply that there is a cause-and-effect relationship between the two variables.
This template runs in Excel, and you can use and modify it to suit your specific needs. For example, you may want to add additional data rows if you want to include more data in the test. You may also redesign the template to allow for data stratification if needed. This is useful if you want to consider different settings for the input variable.
Scatter Diagram Template (20 KB)
Scatter Diagram Template Example (20 KB)