Know About Correlation Function In Excel

Asked By Hawkins Engen 0 points N/A Posted on - 07/15/2020

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?

• Status: Open
• Question Views: 77
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others
• Question Tags: Excel

Answered By Amanda Wissler 10 points N/A #332632

Know About Correlation Function In Excel

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.

About Amanda Wissler

Questions
30

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/15/2020
• Question Category: Software Others