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
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.
Видео How To Create A Correlation Matrix In Excel (With Colors!) канала Top Tip Bio
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.
Видео How To Create A Correlation Matrix In Excel (With Colors!) канала Top Tip Bio
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How To Create A Forest Plot In Excel (Odds Ratios)](https://i.ytimg.com/vi/gD9r3tAZK60/default.jpg)
![Perform A Spearman's Rank Correlation Test In Excel](https://i.ytimg.com/vi/4XGST_Ngwtc/default.jpg)
![](https://i.ytimg.com/vi/vdnoYbfO4vM/default.jpg)
![Variance - Clearly Explained (How To Calculate Variance)](https://i.ytimg.com/vi/x0rmUXWtSS8/default.jpg)
![Top 25 Excel 2016 Tips and Tricks](https://i.ytimg.com/vi/EdnAeqxqdzM/default.jpg)
![Advanced PivotTables: Combining Data from Multiple Sheets](https://i.ytimg.com/vi/Tu6SGU-rK6c/default.jpg)
![How To Perform Simple Linear Regression In Excel](https://i.ytimg.com/vi/9wX1a1J4WOI/default.jpg)
![Most Useful Excel Keyboard Shortcuts](https://i.ytimg.com/vi/iotrTlRT3q0/default.jpg)
![Perform ANOVA Post-Hoc Tests (Bonferroni Correction) In Excel](https://i.ytimg.com/vi/-ZW2uSNmtTo/default.jpg)
![Pearson r Correlation in SPSS - How to Calculate and Interpret (Part 1)](https://i.ytimg.com/vi/3lD6wN6-6C4/default.jpg)
![How to make a correlation matrix in excel using conditional formatting](https://i.ytimg.com/vi/F6gpSq2tm4s/default.jpg)
![Top 15 Advanced Excel 2016 Tips and Tricks](https://i.ytimg.com/vi/PU8ACyYxJBk/default.jpg)
![Pivot Table with Progress Chart and Dashboard](https://i.ytimg.com/vi/cTl3rPLP1cE/default.jpg)
![How To Perform A Simple Linear Regression In R](https://i.ytimg.com/vi/GZti9C_CP0E/default.jpg)
![The Bonferroni Correction - Clearly Explained](https://i.ytimg.com/vi/HLzS5wPqWR0/default.jpg)
![Correlation Matrix](https://i.ytimg.com/vi/uc55cnr8A14/default.jpg)
![How To Create A Bar Chart In Excel (Super Easy!)](https://i.ytimg.com/vi/U5MY9m9mG2c/default.jpg)
![Pivot Table Excel Tutorial](https://i.ytimg.com/vi/m0wI61ahfLc/default.jpg)
![TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel](https://i.ytimg.com/vi/00s5efQWrgU/default.jpg)
![How to Use Color Scales in Excel (Conditional Formatting)](https://i.ytimg.com/vi/fj6VtUi2s9s/default.jpg)