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

✉️ Join my newsletter https://steven-bradburn.beehiiv.com/subscribe 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 https://toptipbio.com/correlation-matrix-excel/ 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 https://techsmith.z6rjha.net/c/1988496/506622/5161 YouTube SEO https://www.tubebuddy.com/SHTeach Software (Microsoft Excel 365 ProPlus) FOLLOW US Website https://toptipbio.com/ Facebook https://www.facebook.com/TopTipBio/ Twitter https://twitter.com/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.