Excel Data Analysis ToolPak - Building a Correlation Matrix

We demonstrate installing Data Analysis ToolPak excel addin and how to build a Karl Pearson Correlation Matrix easily. The data set used can be downloaded from www.learnanalyt... .
Please subscribe to our channel to receive updates and also join our Linkedin Group for latest training videos and articles @ / learn-analytics-step-t...

[@wladimirespinoza3114]

Really simple explanation, no extra bs we didn't needed. You sir, have won the internet. Thanks!

[@jacquelinewang7509]

I LOVE TH-cam. VERY EASY TO KNOW HOW TO DO THIS. THANK YOU, GUYS!

[@andrewhorsfall317]

Easy to follow. Much better job of explaining than my professor.

[@mcesarey]

I'm working on a capstone project and my data uses the likert scale. This video was an absolute savior! Thank you so much!

[@kyraeh]

Thank you for sharing this demonstration of correlation matrix. Look forward to viewing your other videos as I learn more about the toolpak.

[@user-ju7jv4mz2u]

Easy to follow. Love it!

[@gautamanand2117]

Nice, Simple , informative and interpretable.

[@nawafnasser573]

Beautifully explained. Thank you so much for the video.

[@nrajkumar01]

thank you very much for this wonderful video it was awesome...this video made my day..im so relieved...GOD BLESS YOU SIR

[@arianrahman5886]

Brilliant video, gave me exactly what I needed to find out

[@arianrahman5886]

@Aidan Anders No it didn’t

[@drsreelathaguntupalli2124]

Excellent explanation and perfect clarity in explanation. Thank you sooooo much

[@johng5295]

Thanks in a million. Awesome. Very well explained. Where have you been all these years.A+

[@Leah53436]

You are genius at teaching thank you so much!

[@rustemenverov5086]

thanks a lot, I finally find out how to do matrix in new excel!

[@prince49]

Phenomenal video--succinct and informative.

[@angelikakachnowicz6759]

Thank you so much ! God Bless you !

Thank you. Good explanation

[@joe21lester]

Thank you very much Sir.

[@allisonhockey6188]

Sir thank you so much! your tutorials are wonderful! so much to learn :)

[@alis4381]

Subscribed!
Great teaching!

[@leah38521]

SO HELPFUL THANK YOU!!!

[@arunaballa4794]

Thank you so much sir

[@TheSpaceElevator]

Thank you this video is most helpful!

[@KoriTraveler]

Thanks a lot, very clear video

[@robertoross330]

Awesome video, thank you !

[@SiddharthBhatla]

Very Helpful ... Well Explained

[@jasonzhangkekupi]

Thanks for great videos

[@amlandebbarma]

thank u..for the add in part

[@ravitejasadu8087]

Thank You Sir.
Very Useful

[@LizMarianaAguileraRomero]

Thank you so much!

[@shaileshdeshmukh9166]

Thanks Sir

[@srolchi]

Thanks, this video helped me alot.

[@raylk8842]

Excellent thanks!

[@asaurcefulofsecrets]

Nice video. Thanks a lot!

[@dpwhitehead]

very helpful - thanks

[@bisolua]

well done. love it

[@kunjankaim6250]

Awesom!!
Really helpful!!

[@md.arifulislam5888]

Thanks a lot. Please let me know how I'll show this relationship significant or not

[@brigittemorobise7585]

you're amazing..thank you

[@alfredopagliuca2300]

gr8 tip! Thank you

[@tarikusnumidica8229]

thank you its perfect.

[@nareshkatira6599]

How to export it in the same format?

[@HarrySoon08]

MarketXLS works for me well for this.

[@u01sq7]

So if my data is in rows, I would click the rows rather than default option?

[@manzoorwanigeo2335]

How to generate correlation matrix map

[@arpitkumarbaranwal3093]

thanks

[@eckman69]

Very helpful, thanks. Is there a way to get R2 and P values as well?

[@LearnanalyticsIn]

+Erik Eckhardt Excel doesnt give P values (you can try R), R2 is simply the square of the correlation (R)

[@SSSkandeRRR]

great thnx

[@emilywatson6666]

10/10

[@emmalaurie9376]

thank you for this.
my question is how do we know any of them is significant at 0.01 and or 0.05?

[@LearnanalyticsIn]

Excel does not give significance unfortunately; however you can check out rattle if you want a free tool.

[@emmalaurie9376]

Thank you. :D

[@nevermind3425]

Great tutorial
Is it possible to get a copy of the file for practice?
Thanks

[@LearnanalyticsIn]

available at www.learnanalytics.in/blog/?p=150

[@LearnanalyticsIn]

P value of correlation is not given in Excel. You can try R/Rattle

[@julieleung6300]

Is there a way to get a correlation matrix for ordinal and categorical, ordinal and continuous etc?

[@LearnanalyticsIn]

Recode all variables on the likert scale for ordinal, binary one hot for categorical and you are good to go. Use discretion in using the results though, as the scale you use will impact and can inflate correlation values. Use significance tests on the correlation values obtained

[@brianna19]

When I tried to run the correlation matrix I received an error message saying that my data range contained non-numerical data. What could that be referring to?

[@srn2951]

probably you have highlighted the Label Box of the variables without ticking the Label mark from the Regression tool box of options.