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

#excel #correlation
alphabench.com/data/excel-corr...
Please SUBSCRIBE:
ruclips.net/user/subscription_...
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:
alphabench.com/data/linear-re...
The spreadsheet used in this example can be downloaded from:
www.alphabench.com/resourses.html

[@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😁😁😁

[@MattMacarty]

Glad it helped!

[@arthurbukovetsky6322]

It's currently 2:27 in the morning and I am up doing a data task for an interview. Thank you a lot Matt for help!

[@ellaperry2314]

@@arthurbukovetsky6322
hbu bbb hhbbbb
h
uh
hybbbh
hbbb
gn
b
huh
bbb
o

[@ggggy6054]

We all have work to do boo hoo, Ik I’m grumpy rn forgive me

[@SeVeN-os3jl]

It's 11 in the night, and Tomorrow 10 i have my exam...
🥲
But he saved me🙇

[@juanarias701]

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

[@MattMacarty]

Glad it helped

[@retha90]

Thank you, Matt! Just what I needed!

[@MattMacarty]

Glad it helped

[@AllArtsLover]

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

[@MattMacarty]

Glad it helped

[@dd23313]

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

[@MattMacarty]

Thank you. Glad it helped

[@angelawood15]

Clear and concise, thanks for posting.

[@MattMacarty]

Thank you. Glad it helped.

[@BACKpackSouthWest]

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

[@MattMacarty]

Glad it helped

[@Vec135]

you get that PhD?!

[@AGWalp]

@@Vec135 Hey. That is super kind of you to ask! I am in the final stage of the Candidate phase. Thank you. I am praying by the end of the summer if all keeps going as it has so far. Sometimes life gets in the way, but it has been relatively smooth so far (minus the unceasing stress, anxiety, worry, and 0300hrs study times. Lol. No. That is all part of the program. It must be earned.) Thanks again!

[@nictalley4226]

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

[@MattMacarty]

Glad it helped

[@AdamELclon]

this video is very useful, thanks man

[@MattMacarty]

Thanks. Glad it helped.

[@monishamoorthy6715]

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

[@MattMacarty]

Thanks. Glad it helped

[@allistair.oliver]

Brilliant explanation, will never forget it.

[@MattMacarty]

Thanks. Glad it helped.

[@ednareloisekoukoui631]

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

[@MattMacarty]

Glad it helped

[@patrickomara6049]

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

[@MattMacarty]

Glad it helped

[@Tpainful117]

Great video man, thanks.

[@MattMacarty]

Glad it helped

[@alexanderringfield]

Very informative video I appreciate you taking the time to explain this.

[@MattMacarty]

Thanks. Glad it helped.

[@janardantumpal]

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

[@MattMacarty]

Glad it helped.

[@johng5295]

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

[@MattMacarty]

Glad it helped

[@NeverBeenThereBefore]

Thanks Matt.. that's just what i needed

[@MattMacarty]

Glad it helped

[@ARCEuSMILk74]

Thank u! u were so much help

[@MattMacarty]

Glad it helped.

[@kevinleon331]

great example showing what a positive and negative correlation look like

[@MattMacarty]

Glad it helped

[@mayawash10]

Very helpful! Thanks Matt!

[@MattMacarty]

Glad it helped.

[@chloeguacamole]

Thank you this video helped out a lot!

[@MattMacarty]

Glad it helped!

[@karryhe4500]

Very helpful video, Thanks!

[@MattMacarty]

Glad it helped

[@NMEofdaST8]

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

[@MattMacarty]

Glad it helped

[@annaservillo285]

Thank you for this, it use very helpful.

[@MattMacarty]

Glad it helped.

[@Noor-dq6rl]

thank you for helping us out !

[@MattMacarty]

Glad it helped

[@malikabahadori3368]

amazing nice and quick just what i needed thank you!

[@MattMacarty]

Glad it helped!

[@rahulmotwani3845]

Great video. Very helpful!

[@MattMacarty]

Glad to hear it!

[@malikawan3516]

Well done! You are doing good job.. Keep it up ❤️

[@MattMacarty]

Thank you. Glad it helped.

[@ishika5419]

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

[@MattMacarty]

Glad it helped

[@JosephAsamoah]

Hi Matt is it possible to undertake a correlation where the sample size variables are different?

[@MattMacarty]

Thanks for your question. Pearson correlation is calculated using pairs of data points so the sample sizes need to be the same.

[@AscensionINC-zi1jz]

Agreed very concise and to the point.

[@sidrakhalid7611]

Thank you!

[@MattMacarty]

Glad it helped

[@riverviewbaptistchurch2253]

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

[@MattMacarty]

Glad it helped.

[@pallavilondhe1030]

Thank you so much for this.

[@MattMacarty]

Glad it helped

[@johng5295]

Thank you very much.

[@MattMacarty]

Glad it helped

[@diyavinod6304]

Good video, thank you sir, from India

[@MattMacarty]

Glad it helped

[@beautygoratapeleng1434]

Hi Matt, how did you get the positive and negative variable you have there?

[@MattMacarty]

Those are based on a quick linear equation with a random error added in.

[@karenannskreation2022]

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

[@MattMacarty]

Glad it helped

[@jonahoyisi6610]

Thank you sir !

[@MattMacarty]

Glad it helped

[@racheltam8032]

nice teaching !

[@MattMacarty]

Glad it helped

[@izzatiehadi5236]

thanks for video.

[@MattMacarty]

Glad it helped.

[@wendersonferreira9081]

Very good., thanks

[@MattMacarty]

Glad it helped

[@celticbabs3105]

God bless you

[@MattMacarty]

Glad it helped.

[@jillianvelilia3064]

hello can I ask if where did you get the x and the none column. Because our professor only give us 2 samples

[@MattMacarty]

x is the independent variable, and the other three columns are examples of positive, negative and NO correlation. That's the one I labeled none. You can follow the link in the description to download the data file if that would help.

[@brittanywhite3151]

Thank you so much.

[@MattMacarty]

Glad it helped

[@nimet5242]

Hi Matt, thanks for the video. What about yes and no column? Is that ok to replace them 0 and 1 and apply same process what you just explained?

[@MattMacarty]

Sure. I was just using that to show positive/negative correlations

[@studywithyeya3052]

Thanks! really helpful

[@MattMacarty]

Glad it helped!

[@studywithyeya3052]

@@MattMacarty yes! the explanations are clear and simple too! looking forward for more stat vids. thanks! more power

[@MattMacarty]

@@studywithyeya3052 Thanks. Glad it helped.

[@curateitgorl]

Thank you thank you

[@MattMacarty]

Glad it helped.

[@user-xv7cs5hu1s]

thank you for sharing the excel file too

[@MattMacarty]

You are welcome. Glad it helped

[@r-c2082]

Thank you

[@MattMacarty]

Glad it helped

[@phucnguyen-vp2bo]

Character In the video It's great, I like it a lot $$

[@MattMacarty]

Glad it helped

[@jordan-ef4xn]

Fthank you

[@MattMacarty]

Glad it helped

[@albertcornelles5256]

gracias dios por aparecer en este momento oportuno
voy a empezar a rezar

[@MattMacarty]

Glad it helped.

[@husseinmsi3800]

Could you please tell me how to activate function pane that you said?

[@MattMacarty]

Click on the fx button on the left side of the formula bar

[@beverlysimple411]

Thanks alot.

[@MattMacarty]

Glad it helped

[@ameeralbulushi2199]

thanks

[@MattMacarty]

Glad it helped!

[@bibimeme5572]

What if I have diff headings as 1 column had I'd no, 2nd one is ethnicity, 3rd one gender, 4 education level? And I wanna find corellation bw education level and gender then?

[@MattMacarty]

The process the same, only the column names have changed. You can also generate a table of correlations if you want: ruclips.net/video/DywVjSgkAR4/видео.html

[@ericacounter8340]

Although this does not show how you get the little table that you have in your workbook, in there..

[@MattMacarty]

I just set that up ahead manually. I put a thick border and used cell styles.

[@ayaahmed7146]

if we compare the positive and negative correlation, the positive is stronger because its closer to one than the negative value (which is further away from -1)??? Right?

[@MattMacarty]

Yes

[@ajayrana7718]

Hello sir how to find correlation and significance value between environmental variables and diversity indices

[@MattMacarty]

The procedure for correlation will follow the demonstration in the video. To test for significance requires a longer explanation. There are a couple of methods you could use but it is not something I can explain briefly here.

[@bebrownbear8354]

Do i need to see p value with this?

[@MattMacarty]

This is just showing the mechanics of correlation. p-value refers to testing correlation for significance.

[@jackbou3r486]

Not sure if just me, but the link to the sheet doesn't seem to be working any longer

[@MattMacarty]

Hi. I just tested and it seems to be working: alphabench.com/data/excel-correlation-tutorial.html

[@sithlordmaster181]

Can't seem to find where to download the data, I keep getting sent in circles.

[@MattMacarty]

Sorry about that: alphabench.com/data/excel-correlation-tutorial.html

[@nadk4448]

What would -0.249 be considered as?? Thank you

[@MattMacarty]

Weakish negative but likely significant

[@irmak1074]

What would a correlation number of 0.48 be?

[@MattMacarty]

Do you mean how strong is the relationship? This is moderately correlated

[@irmak1074]

@@MattMacarty Yes! Thank you

[@komalbaig38]

From where we get positive and negative ?? Column?

[@MattMacarty]

I generated the numbers randomly. To get a negative correlation you use the first column and the column labeled negative. Make appropriate change for positive.

[@newsdaily5186]

can we find correlation to the letters?

[@MattMacarty]

I don't think I follow you.

[@newsdaily5186]

@@MattMacarty i didn't understand?

[@JohnDoe-tw5dg]

I think he might be asking if it is possible to find correlations based on letters instead of numbers

[@okechogoye6453]

VERY GOOD WORK BUT UNCLEAR VIDEO

[@MattMacarty]

Sorry about that. If you click on the little gear icon near the bottom of the video, you can select to view in HD which will clear it up

[@okechogoye6453]

@@MattMacarty,Thanks

[@kathleenannsanbuenaventura2541]

What is X referring to?

[@MattMacarty]

The variable on the x axis

[@kathleenannsanbuenaventura2541]

@@MattMacarty Thank you so much Sir! Now I can finish my output in Statistics.

[@maanajlan7056]

Is 0.222 is good relationship?!

[@MattMacarty]

So I wouldn't characterize relationships as good or bad. Maybe weak or strong or significant. The number in isolation doesn't tell me much, but I would presume that at the very lest this correlation is significantly different from 0.

[@asunayuuki894]

I hate Excel☺️

[@MattMacarty]

Sorry.

[@ange6444]

Thank you !

[@MattMacarty]

Glad it helped