How To Create A Correlation Matrix In Excel (With Colors!)

[@StevenBradburn]

ONLINE GUIDE toptipbio.com/correlation-matrix-excel/

[@malloryalvacastaneda2547]

Hello sir.Is 0.5 and 0.2 a posive linear correlatiom? Thank yoy

[@StevenBradburn]

@@malloryalvacastaneda2547 yep. Positive values indicate a positive relationship. With values closest to 1 being a stronger relationship compared with those closer to 0

[@malloryalvacastaneda2547]

@@StevenBradburn Thank you. I am having a hard time on data analytics. I have watched and repeated some of your videos.it helped a lot. thank you

[@adelaidesharp3718]

This helped me understand how to complete an assessment worth 45% of my overall grade, thank you so so much. You are the only reason I was able to progress.

[@nzumbun3485]

Oooo my God. bro you just answered my 6 months struggle in less than 8 minutes. come here let me give you a kiss

[@adilch3079]

😂

[@melindajones8644]

I have watched so many video, read so many chapters and nothing made sense. This is by far the most helpful tutorial. Thank you so much.

[@kanizfarzana7626]

You are doing an excellent jobs helping the students and researchers . Thank you so much

[@Chilly2024]

This is brilliant excellent detail in short video

[@tatekeplinger1429]

Exactly what I was looking for... half way through building my own matrix by hand one CORREL formula at a time! Thanks!

[@thomass8553]

🤣

[@guilhermeviolin]

Amazing tutorial. Thank you very much

[@masegoswife]

THE BEST TUTORIAL EVER!!!!!❤❤❤

[@toddschmieder7873]

Absolutely awesome brother! Thank you!!!

[@Jay0179]

Life saver right here.. thank you Sir

[@julioandrelaranjo2302]

Very nice! Thanks! 👏🏻👏🏻👏🏻

[@BhaveshPatel-q6h]

You are a life saver. Keep up good work.

[@kalyansundarsamanta]

This is indeed a good tutorial. I learned lot. Thank you sir.

[@nhbr4034]

thank you for the guide, it's my first time doing this through excel

[@zainabkhan2475]

No tutorial could be better. Thank you

[@rahulmotwani3845]

This was very helpful thanks!! needed this to analyse the data of my survey for dissertation.

[@morgantitus248]

OMG i just about did this manually lol wow. You are a life saver my man

[@danjarupath]

Great 👍👍👍

[@princeanshul7950]

you solved one of my big problems in just a few mins, thanks.

[@gajanumeenu6153]

really thank you brother for this content .i expect more from you like this tutorial

[@obasiezekieluchechukwu3726]

Best explanation so far!🥂

[@Bright-he9ck]

So with this, I don't even need R studio or python to do this. Thank you. I just liked and subscribed.

[@reghunadhan6588]

universe bless you. thankyou so much!! saved me!!

[@mankemrelindis2451]

The best I have seen so far thank you

[@srimathiravichandran3378]

Very clear explanation. Thank you so much

[@TwiztedHumor]

Beautiful explanation, thanks for your help!

[@SufiMaverick]

Thank you so much for your tutorial. Really saved my day!

[@glorialiu3564]

very clear and practical enough! Thank you!

[@DoreenvanderWalt]

Thank you. Very useful!

[@akramgashtasebi7028]

It was very useful for me. thanks a lot

[@MabelFilms]

thanks mate, helped me with a project

[@truongvuolap143]

Perfect tutorial

[@louiefuentes1845]

Thank you so much for this. I am currently doing my thesis using EGOVSAT model to measure multiple predictors.

[@katieboyle5421]

Great tutorial! Thank you so much, made it all seem super easy!

[@ThaWalrus92]

Awesome work man

[@RealKevinOnYouTube]

Thanks for the tutorial! Helped me a bunch for my stats class!

[@nichaelryan8486]

Explains better than my master degree lecturer :)

[@lordxenakius6920]

Thank you very much my kind sir, that was extremely helpful.

[@krerkchetsadanuwat1511]

Great tutorial 🎉🎉🎉🎉

[@tennysontm3740]

Thank you !!! this helped me a lot.

[@jaimedpcaus1]

Super cool! I bet this replaces the matrix plot with more than one variable in minitab!

[@PiduguVijay]

Your tutorial is awesome

[@kemohits2017]

so useful thank you

[@manuelgonzales2570]

Very good. Thanks!

[@alexandreribeirocardoso8654]

Duuude, thank you SO much!

[@mozgurcelik]

Thank you so much for valuable the video😊

[@StevenBradburn]

My pleasure 😊

[@weamfezaa3163]

Thank u so much 🎉🎉🎉🎉

[@engtarawneh90]

Thank you

[@muktaabhichandani4941]

Thank you so much for this video.. too helpful 💯

[@pallabidas9208]

Very Helpful. Thanks

[@sairam-qy3rm]

Thank you so so so much❤❤😘👌👌❤️

[@zinimbita9789]

well explained

[@madyramos8921]

Great video, great explanation Thank you Sir

[@StevenBradburn]

You are welcome

[@adoublanchardgnagne1548]

Thank you for this movie. it help me a lot

[@yonelamaziko287]

Enlightening video thanks

[@KameshwarChoppella]

Amazing! great job!

[@mohamedmohamedabdallah13]

you are awesome dude

[@lifeiseco7688]

A lot of thanks Sir

[@echosoft3375]

Nice expleaination many thanks

[@googleuser2271]

Vielen Dank aus Deutschland!!

[@ayanabhakole8901]

How to get the bar showing the colour ranges?

[@user-pq33]

Thank you

[@cooper8617]

a godsend 🙏

[@websintern7713]

Really helpful!

[@johnayers2077]

Hello Steven. Great information given here. After going through and attempting to use this, I received an error message that says Correlation - Input Range contains non-numeric data. Having a hard time trying to figure this out. Went through the data set to make sure everything was correct and it is. Any suggestions or assistance would be greatly appreciated.

[@talmonf]

Great video, thank you! Is there a way I could click on a cell and get a scatter plot shown for the 2 variables?

[@ernalieysip6061]

Are the variables in the upper part are the questions?

[@ramneek4344]

best thanks

[@hassanalianees5530]

Thanks a lot

[@Augustxjay]

I love this. God bless you. But I have a question. How can we do a dataset with many countries. Eg sub Saharan countries.

[@WallStWarLord]

May I please inquire as to whether you can provide the step-by-step directions and instructions as to how to create this same live Correlation Index in Excel...and more specifically with the use of Microsoft Excel RTD/Real-Time Edition...and whereas I am seeking to establish a realtime stock market DDE/dynamic link and whereby an array of stock market exchange tick-by-tick trades are constantly and instantly updated autonomically/automatically @ ultra high-frequency within this Correlation Index Matrix..Thank you

[@kingkamaro9442]

Perfect.

[@RainfallResonance]

Thanks for the useful video. How can populate the upper part of the matrix?

[@BSMalikvlogs]

could please make video on "how to create excel data sheet for Pearson correlation coefficient from worldclim data". please please

[@Tota-tj5oh]

Braaaaavoooooo for any thing her say

[@danabasheer1954]

how to test the signifince of correlation coefficient?can you pls explain

[@StevenBradburn]

Suggest you watch this: kzbin.info/www/bejne/e6ebZ3eDqbGLhc0

[@jerricdelfin6159]

Arigiti gozaimasu

[@POOJASHARMA-wv1cp]

how to consider non numeric data?

[@mousumisarkar5277]

Can I know the p-values of the correlation matrix?

[@MuhammadUmarbotanist]

how to add the scale in this correlation matrix??

[@tr4v15r055]

thank you for this. After color-coding the cells, is it possible to sort them into clusters according to color? Similar to a clustered matrix.

[@samirelzein1978]

i d ve put the blue for "cold"/negative and red for "hot"/posistive

[@Amitkumar014]

Help!!! I am getting getting #DIV/0! Instead of the numbers in the correlation table, I followed the same steps.

[@tatemuta77]

wow

[@bryanadriel6036]

How to transfer a correlation matrix to a ppt

[@kirtipanditakoul3928]

👍🏻👍🏻👍🏻👍🏻👍🏻

[@dhruvrajput4104]

Hindich video bna kakkeee😈

[@ksham8715]

Only tamil telegu and kannadda no hinthi 🥷🏿😡

[@dhruvrajput4104]

​@@ksham8715🤙🏻

[@firasaljanabi3349]

Very clear. Thank you so much

[@big_nachalnik]

Thanks a lot