Calculating the Pearson correlation coefficient can be complicated but software makes it much easier. You can use several methods to calculate correlation in Excel.

While Excel includes a legend automatically when you create the scatter plot, there are a number of ways to delete it; if your legend is missing you can get it back through the "Layout" tab.

Want to know how to create a scatter plot in Excel? Here's a guide on how we created a simple chart based on performance numbers.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

How to Make a Scatterplot on Excel. A scatterplot chart graphs two related data values as a single dot by plotting one value on the horizontal X axis and the other value on the vertical Y axis ...

Fact checked by Pete Rathburn Reviewed by Chip Stapleton What Is Correlation? Correlation measures the linear relationship between two variables. By measuring and relating the variance of each ...