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

Просмотров 763 тыс.

% 3 235

#excel #correlation
alphabench.com/data/excel-correlation-tutorial.html
Please SUBSCRIBE:
ru-vid.com
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-regression.html
The spreadsheet used in this example can be downloaded from:
www.alphabench.com/resourses.html

Наука

Опубликовано:

6 окт 2016

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 164

@The_Yilling_Laozu 2 года назад

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 2 года назад

Glad it helped!

@arthurbukovetsky6322 2 года назад

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 9 месяцев назад

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

@SeVeN-os3jl 8 месяцев назад

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

@TomislavLukic-sl9gx 9 дней назад

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

@MattMacarty День назад

Glad it helped

@juanarias701 6 лет назад

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

@MattMacarty 6 лет назад

Glad it helped

@AllArtsLover 3 года назад

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

@MattMacarty 3 года назад

Glad it helped

@retha90 4 года назад

Thank you, Matt! Just what I needed!

@MattMacarty 4 года назад

Glad it helped

@dd23313 Год назад

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

@MattMacarty Год назад

Thank you. Glad it helped

@angelawood15 5 лет назад

Clear and concise, thanks for posting.

@MattMacarty 5 лет назад

Thank you. Glad it helped.

@BACKpackSouthWest 2 года назад

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

@MattMacarty 2 года назад

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!

@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

@nictalley4226 4 года назад

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

@MattMacarty 4 года назад

Glad it helped

@monishamoorthy6715 2 года назад

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

@MattMacarty 2 года назад

Thanks. Glad it helped

@patrickomara6049 Год назад

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

@MattMacarty 11 месяцев назад

Glad it helped

@allistair.oliver 2 года назад

Brilliant explanation, will never forget it.

@MattMacarty 2 года назад

Thanks. Glad it helped.

@AdamELclon 6 лет назад

this video is very useful, thanks man

@MattMacarty 6 лет назад

Thanks. Glad it helped.

@kevinleon331 3 года назад

great example showing what a positive and negative correlation look like

@MattMacarty 3 года назад

Glad it helped

@alexanderringfield 3 года назад

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

@MattMacarty 3 года назад

Thanks. Glad it helped.

@janardantumpal 3 года назад

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

@MattMacarty 3 года назад

Glad it helped.

@Tpainful117 4 года назад

Great video man, thanks.

@MattMacarty 4 года назад

Glad it helped

@NeverBeenThereBefore 3 года назад

Thanks Matt.. that's just what i needed

@MattMacarty 3 года назад

Glad it helped

@johng5295 4 года назад

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

@MattMacarty 4 года назад

Glad it helped

@ARCEuSMILk74 5 лет назад

Thank u! u were so much help

@MattMacarty 5 лет назад

Glad it helped.

@chloeguacamole Год назад

Thank you this video helped out a lot!

@MattMacarty Год назад

Glad it helped!

@sidrakhalid7611 5 лет назад

Thank you!

@MattMacarty 5 лет назад

Glad it helped

@annaservillo285 3 года назад

Thank you for this, it use very helpful.

@MattMacarty 3 года назад

Glad it helped.

@Noor-dq6rl 2 года назад

thank you for helping us out !

@MattMacarty 2 года назад

Glad it helped

@johng5295 4 года назад

Thank you very much.

@MattMacarty 4 года назад

Glad it helped

@diyavinod6304 3 года назад

Good video, thank you sir, from India

@MattMacarty 3 года назад

Glad it helped

@ishika5419 Год назад

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

@MattMacarty Год назад

Glad it helped

@malikawan3516 3 года назад

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

@MattMacarty 3 года назад

Thank you. Glad it helped.

@karenannskreation2022 8 месяцев назад

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

@MattMacarty 8 месяцев назад

Glad it helped

@karryhe4500 11 месяцев назад

Very helpful video, Thanks!

@MattMacarty 11 месяцев назад

Glad it helped

@malikabahadori3368 5 месяцев назад

amazing nice and quick just what i needed thank you!

@MattMacarty 5 месяцев назад

Glad it helped!

@mayawash10 5 лет назад

Very helpful! Thanks Matt!

@MattMacarty 5 лет назад

Glad it helped.

@pallavilondhe1030 Год назад

Thank you so much for this.

@MattMacarty Год назад

Glad it helped

@jonahoyisi6610 4 года назад

Thank you sir !

@MattMacarty 4 года назад

Glad it helped

@rahulmotwani3845 8 месяцев назад

Great video. Very helpful!

@MattMacarty 8 месяцев назад

Glad to hear it!

@racheltam8032 4 года назад

nice teaching !

@MattMacarty 4 года назад

Glad it helped

@izzatiehadi5236 4 года назад

thanks for video.

@MattMacarty 4 года назад

Glad it helped.

@beautygoratapeleng1434 4 года назад

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

@MattMacarty 4 года назад

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

@celticbabs3105 4 года назад

God bless you

@MattMacarty 4 года назад

Glad it helped.

@NMEofdaST8 3 года назад

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

@MattMacarty 3 года назад

Glad it helped

@brittanywhite3151 2 года назад

Thank you so much.

@MattMacarty 2 года назад

Glad it helped

@JosephAsamoah 6 лет назад

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

@MattMacarty 6 лет назад

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

@AscensionINC-zi1jz 5 лет назад

Agreed very concise and to the point.

@riverviewbaptistchurch2253 4 года назад

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

@MattMacarty 4 года назад

Glad it helped.

@user-xv7cs5hu1s 2 года назад

thank you for sharing the excel file too

@MattMacarty 2 года назад

You are welcome. Glad it helped

@studywithyeya3052 3 года назад

Thanks! really helpful

@MattMacarty 3 года назад

Glad it helped!

@studywithyeya3052 3 года назад

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

@MattMacarty 3 года назад

@@studywithyeya3052 Thanks. Glad it helped.

@wendersonferreira9081 Год назад

Very good., thanks

@MattMacarty Год назад

Glad it helped

@nimet5242 6 месяцев назад

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 6 месяцев назад

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

@jillianvelilia3064 2 года назад

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

@MattMacarty 2 года назад

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.

@curateitgorl 2 года назад

Thank you thank you

@MattMacarty 2 года назад

Glad it helped.

@phucnguyen-vp2bo 2 года назад

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

@MattMacarty 2 года назад

Glad it helped

@beverlysimple411 3 года назад

Thanks alot.

@MattMacarty 3 года назад

Glad it helped

@r-c2082 2 года назад

Thank you

@MattMacarty 2 года назад

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

@jordan-ef4xn 6 лет назад

Fthank you

@MattMacarty 6 лет назад

Glad it helped

@ameeralbulushi2199 5 лет назад

thanks

@MattMacarty 5 лет назад

Glad it helped!

@ericacounter8340 4 года назад

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

@MattMacarty 4 года назад

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

@ayaahmed7146 3 года назад

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 3 года назад

Yes

@albertcornelles5256 5 лет назад

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

@MattMacarty 5 лет назад

Glad it helped.

@ajayrana7718 3 года назад

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

@MattMacarty 3 года назад

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.

@jackbou3r486 3 года назад

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

@MattMacarty 3 года назад

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

@sithlordmaster181 4 года назад

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

@MattMacarty 4 года назад

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

@nadk4448 3 года назад

What would -0.249 be considered as?? Thank you

@MattMacarty 3 года назад

Weakish negative but likely significant

@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.

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DywVjSgkAR4.html

@komalbaig38 3 года назад

From where we get positive and negative ?? Column?

@MattMacarty 3 года назад

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.

@irmak1074 3 года назад

What would a correlation number of 0.48 be?

@MattMacarty 3 года назад

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

@irmak1074 3 года назад

@@MattMacarty Yes! Thank you

@newsdaily5186 3 года назад

can we find correlation to the letters?

@MattMacarty 3 года назад

I don't think I follow you.

@newsdaily5186 3 года назад

@@MattMacarty i didn't understand?

@JohnDoe-tw5dg 2 года назад

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

@kathleenannsanbuenaventura2541 4 года назад

What is X referring to?

@MattMacarty 4 года назад

The variable on the x axis

@kathleenannsanbuenaventura2541 4 года назад

@@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.