How To Calculate Correlation In Excel

Using the CORREL function for the scatter plot helps with interpreting and analyzing data.
In this video, you'll see how to use this function in 7 steps:
Go to the Data tab.
Select the Data Analysis tool.
Select the Correlation tool from the Data Analysis dialogue box.
Press OK to open the Correlation dialogue box.
Input your data to the Input Range.
Turn on the Output Range and select an empty cell.
Press OK.

Subscribe for more new tips and tricks to have better experiences while working with excel.v