How to calculate correlation coefficient in Excel

Hello, My Dear Friends, !! In this video, I will show you how to calculate the correlation coefficient in Excel. Watch the video till the end Thanks.

Here,s how to calculate the correlation coefficient in Excel:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Step 1: Open Excel.

Step 2: Install the Analysis Toolpak.

Step 3: Select “Data” from the top bar menu.

Step 4: Select “Data Analysis” in the top right-hand corner.

Step 5: Select Correlation.

Step 6: Define your data range and output.

Step 7: Evaluate your correlation coefficient.

Chapters: 

0:00  Introduction 

0:17  Calculate the correlation coefficient in Excel  

1:22  Happy Ending

Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel.

#initial #solution #calculate #correlation #coefficient #in #excel