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!

[@andrewhorsfall317]

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

[@nrajkumar01]

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

[@김두현-s8p]

Easy to follow. Love it!

[@jacquelinewang7509]

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

[@manzoorwanigeo2335]

How to generate correlation matrix map

[@joe21lester]

Thank you very much Sir.

[@nareshkatira6599]

How to export it in the same format?

[@LearnanalyticsIn]

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

[@arunaballa4794]

Thank you so much sir

[@nawafnasser573]

Beautifully explained. Thank you so much for the video.

[@johng5295]

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

[@arianrahman5886]

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

[@arianrahman5886]

@Aidan Anders No it didn’t

[@shaileshdeshmukh9166]

Thanks Sir

[@prince49]

Phenomenal video--succinct and informative.

[@u01sq7]

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

[@kyraeh]

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

Thank you. Good explanation

[@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!

[@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

[@emilywatson6666]

10/10

[@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.

[@drsreelathaguntupalli2124]

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

[@HarrySoon08]

MarketXLS works for me well for this.

[@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

[@gautamanand2117]

Nice, Simple , informative and interpretable.

[@rustemenverov5086]

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

[@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)

[@KoriTraveler]

Thanks a lot, very clear video

[@srolchi]

Thanks, this video helped me alot.

[@md.arifulislam5888]

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

[@allisonhockey6188]

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

[@angelikakachnowicz6759]

Thank you so much ! God Bless you !

[@ravitejasadu8087]

Thank You Sir.
Very Useful

[@TheSpaceElevator]

Thank you this video is most helpful!

[@alis4381]

Subscribed!
Great teaching!

[@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

[@robertoross330]

Awesome video, thank you !

[@Leah53436]

You are genius at teaching thank you so much!

[@LizMarianaAguileraRomero]

Thank you so much!

[@SiddharthBhatla]

Very Helpful ... Well Explained

[@brigittemorobise7585]

you're amazing..thank you

[@jasonzhangkekupi]

Thanks for great videos

[@amlandebbarma]

thank u..for the add in part

[@tarikusnumidica8229]

thank you its perfect.

[@alfredopagliuca2300]

gr8 tip! Thank you

[@kunjankaim6250]

Awesom!!
Really helpful!!

[@dpwhitehead]

very helpful - thanks

[@leah38521]

SO HELPFUL THANK YOU!!!

[@asaurcefulofsecrets]

Nice video. Thanks a lot!

[@arpitkumarbaranwal3093]

thanks

[@raylk8842]

Excellent thanks!

[@SSSkandeRRR]

great thnx

[@bisolua]

well done. love it