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

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

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

[@kanizfarzana7626]

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

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

[@katieboyle5421]

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

[@glorialiu3564]

very clear and practical enough! Thank you!

[@RealKevinOnYouTube]

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

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

[@louiefuentes1845]

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

[@princeanshul7950]

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

[@kalyansundarsamanta]

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

[@srimathiravichandran3378]

Very clear explanation. Thank you so much

[@TwiztedHumor]

Beautiful explanation, thanks for your help!

[@masegoswife]

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

[@rahulmotwani3845]

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

[@gajanumeenu6153]

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

[@guilhermeviolin]

Amazing tutorial. Thank you very much

[@jaimedpcaus1]

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

[@SufiMaverick]

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

[@Chill-y2398]

This is brilliant excellent detail in short video

[@mankemrelindis2451]

The best I have seen so far thank you

[@muktaabhichandani4941]

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

[@nhbr4034]

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

[@PiduguVijay]

Your tutorial is awesome

[@pallabidas9208]

Very Helpful. Thanks

[@ThaWalrus92]

Awesome work man

[@user-qe5dw9lp1v]

Thank you. Very useful!

[@tennysontm3740]

Thank you !!! this helped me a lot.

[@KameshwarChoppella]

Amazing! great job!

[@akramgashtasebi7028]

It was very useful for me. thanks a lot

[@lordxenakius6920]

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

[@websintern7713]

Really helpful!

[@truongvuolap143]

Perfect tutorial

[@krerkchetsadanuwat1511]

Great tutorial 🎉🎉🎉🎉

[@MabelFilms]

thanks mate, helped me with a project

[@yonelamaziko287]

Enlightening video thanks

[@morgantitus248]

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

[@danjarupath]

Great 👍👍👍

[@manuelgonzales2570]

Very good. Thanks!

[@adoublanchardgnagne1548]

Thank you for this movie. it help me a lot

[@alexandreribeirocardoso8654]

Duuude, thank you SO much!

[@kemohits2017]

so useful thank you

[@echosoft3375]

Nice expleaination many thanks

[@lifeiseco7688]

A lot of thanks Sir

[@sairam-qy3rm]

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

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

[@googleuser2271]

Vielen Dank aus Deutschland!!

[@zinimbita9789]

well explained

[@mohamedmohamedabdallah13]

you are awesome dude

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

[@kingkamaro9442]

Perfect.

[@hassanalianees5530]

Thanks a lot

[@nichaelryan8486]

Explains better than my master degree lecturer :)

[@user-pq33]

Thank you

[@ramneek4344]

best thanks

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

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

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

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

[@jerricdelfin6159]

Arigiti gozaimasu

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

[@kirtipanditakoul3928]

👍🏻👍🏻👍🏻👍🏻👍🏻

[@tatemuta77]

wow

[@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: ua-cam.com/video/Ev86DMtLXOk/v-deo.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