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

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)
Software (Microsoft Excel 365 ProPlus)

FOLLOW US

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.

[nzumbun]

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

[adelaidesharp]

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.

[neilhess]

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!

[kanizfarzana]

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

[melindajones]

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.

[tatekeplinger]

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

[Chilly]

This is brilliant excellent detail in short video

[zainabkhan]

No tutorial could be better. Thank you

[morgantitus]

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

[kalyansundarsamanta]

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

[nhbr]

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

[princeanshul]

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

[rahulmotwani]

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

[gajanumeenu]

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

[SufiMaverick]

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

[glorialiu]

very clear and practical enough! Thank you!

[akramgashtasebi]

It was very useful for me. thanks a lot

[TwiztedHumor]

Beautiful explanation, thanks for your help!

[lordxenakius]

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

[srimathiravichandran]

Very clear explanation. Thank you so much