Recently I am working with the excel and I want to use the correlation function but I don’t know what is correlation function and how correlation function in excel used so can you tell me?
The correlation function tells how the two variables are strongly related to each other. In excel the CORREL function is used to find the correlation coefficient between the two points.
Steps to use correlation function in excel:
1. First, open the excel on the Data tab clicks on the Data Analysis.
2. Now select the correlation and click on ok.
3. For example, if you select the row A1 to C6 as an input.
4. Now on the dialogue box check the box of Labels in the first row.
5. Then select A8 sell for the output.
6. Now click on ok.
7. Following are the result of the correlation function.
