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

In this video, I’m going to show you how to create a correlation matrix in Microsoft Excel. I will show you how to calculate the Pearson correlation coefficient values for each association, and I’ll even show you how to color code each cell to represent the strength of each correlation.
ONLINE GUIDE
toptipbio.com/correlation-mat...
VIDEO CHAPTERS
00:00 Intro
00:25 My example data
00:50 Installing Analysis ToolPak
01:26 Creating the correlation matrix
02:55 Interpreting the results
05:19 Color code the cells
07:05 Summary
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
TH-cam SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

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

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

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

[@neilhess2518]

Dude, I wish more tutorial videos were like this: Quick, good explanations with examples, no stupid fluff where people think they are comedians. Just GREAT content!

[@StevenBradburn]

Thanks Neil. Appreciate that

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

[@glorialiu3564]

very clear and practical enough! Thank you!

[@tatekeplinger1429]

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

[@thomass8553]

🤣

[@zainabkhan2475]

No tutorial could be better. Thank you

[@katieboyle5421]

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

[@masegoswife]

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

[@RealKevinOnYouTube]

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

[@srimathiravichandran3378]

Very clear explanation. Thank you so much

[@TwiztedHumor]

Beautiful explanation, thanks for your help!

[@kalyansundarsamanta]

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

[@mankemrelindis2451]

The best I have seen so far thank you

[@princeanshul7950]

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

[@louiefuentes1845]

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

[@PiduguVijay]

Your tutorial is awesome

[@guilhermeviolin]

Amazing tutorial. Thank you very much

[@pallabidas9208]

Very Helpful. Thanks

[@ThaWalrus92]

Awesome work man

[@Chill-y2398]

This is brilliant excellent detail in short video

[@truongvuolap143]

Perfect tutorial

[@gajanumeenu6153]

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

[@websintern7713]

Really helpful!

[@KameshwarChoppella]

Amazing! great job!

[@SufiMaverick]

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

[@user-qe5dw9lp1v]

Thank you. Very useful!

[@muktaabhichandani4941]

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

[@rahulmotwani3845]

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

[@nhbr4034]

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

[@yonelamaziko287]

Enlightening video thanks

[@tennysontm3740]

Thank you !!! this helped me a lot.

[@krerkchetsadanuwat1511]

Great tutorial 🎉🎉🎉🎉

[@kemohits2017]

so useful thank you

[@manuelgonzales2570]

Very good. Thanks!

[@akramgashtasebi7028]

It was very useful for me. thanks a lot

[@jaimedpcaus1]

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

[@alexandreribeirocardoso8654]

Duuude, thank you SO much!

[@lifeiseco7688]

A lot of thanks Sir

[@MabelFilms]

thanks mate, helped me with a project

[@lordxenakius6920]

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

[@zinimbita9789]

well explained

[@googleuser2271]

Vielen Dank aus Deutschland!!

[@echosoft3375]

Nice expleaination many thanks

[@kingkamaro9442]

Perfect.

[@adoublanchardgnagne1548]

Thank you for this movie. it help me a lot

[@sairam-qy3rm]

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

[@hassanalianees5530]

Thanks a lot

[@morgantitus248]

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

[@danjarupath]

Great 👍👍👍

[@mohamedmohamedabdallah13]

you are awesome dude

[@user-pq33]

Thank you

[@nichaelryan8486]

Explains better than my master degree lecturer :)

[@ramneek4344]

best thanks

[@madyramos8921]

Great video, great explanation
Thank you Sir

[@StevenBradburn]

You are welcome

[@RainfallResonance]

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

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

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

[@Tota-tj5oh]

Braaaaavoooooo for any thing her say

[@jerricdelfin6159]

Arigiti gozaimasu

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

[@ernalieysip6061]

Are the variables in the upper part are the questions?

[@samirelzein1978]

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

[@tatemuta77]

wow

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

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

[@BSMalikvlogs]

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

[@kirtipanditakoul3928]

👍🏻👍🏻👍🏻👍🏻👍🏻

[@MuhammadUmarbotanist]

how to add the scale in this correlation matrix??

[@mousumisarkar5277]

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

[@danabasheer1954]

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

[@StevenBradburn]

Suggest you watch this: th-cam.com/video/Ev86DMtLXOk/w-d-xo.html

[@Amitkumar014]

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

[@bryanadriel6036]

How to transfer a correlation matrix to a ppt

[@user-sp4qs2ip6i]

Thanks a lot