Using Excel to calculate a correlation coefficient || interpret relationship between variables

#excel #correlation

Please SUBSCRIBE:

This tutorial demonstrates how to use the CORREL function in Excel to calculate and interpret the strength and direction of the relationship between two variables.
You may also be interested in Linear Regression:

The spreadsheet used in this example can be downloaded from:

[The_Yilling_Laozu]

It's currently 3:15 in the morning and I'm up doing an assignment using excel. Thanks so much Matt. I didn't understand a thing in my lecture but now I do😁😁😁

[TomislavLukic-slgx]

In shortest possible time you said all important things. Thanks!

[juanarias]

Very good, 5 min spent to remember the correl concept. Thanks for posting.

[BACKpackSouthWest]

Much appreciated, Matt! This is the part of my Ph.D. I fear the most, but you just brought me some comfort.

[ednareloisekoukoui]

Honestly you saved me. I was confused with Eviews. I did it using Excel. Thank you so much. Stay blessed

[allistair.oliver]

Brilliant explanation, will never forget it.

[monishamoorthy]

Thank you for this video, it was simple and very well explained all the three scenarios.

[kevinleon]

great example showing what a positive and negative correlation look like

[patrickomara]

Thank you for explaining this so thoroughly, it really helped me understand what I'm doing.

[dd]

Amazing job Matt! Easy to understand and direct to the point. Great job

[angelawood]

Clear and concise, thanks for posting.

[AllArtsLover]

Thank you. Perfect; covers all bases including reminders of how correlations should be interpreted.

[ishika]

Thank u so much SIR, it is very helpful to me. 😍 🇮🇳 🇮🇳

[riverviewbaptistchurch]

Literally was about to cry because I didn’t get my hw but this helped!!!

[karenannskreation]

Thank you for the video this video help me greatly 2023 Applied Statistics

[NMEofdaST]

Hell yeah thank you! using may more numbers and larger values in the millions and this scales perfectly!

[janardantumpal]

Thanks a bunch...I struggled with that mammoth formula and my data size...your video was very helpful...

[nictalley]

Thank you very much for this tutorial, it was extremely helpful.

[johng]

Thanks in a million. Awesome. Very well explained. Where have you been all these years.A+

[AdamELclon]

this video is very useful, thanks man