How To Create A Correlation Matrix In Excel (With Colors!)
✉️ Join my newsletter
https://steven-bradburn.beehiiv.com/s...
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-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 https://techsmith.z6rjha.net/c/198849...
YouTube SEO https://www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website https://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.
Watch video How To Create A Correlation Matrix In Excel (With Colors!) online, duration hours minute second in high quality that is uploaded to the channel Steven Bradburn 20 April 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 236,994 times and liked it 4 thousand visitors.
