Summary Statistics and Correlation Analysis in Excel Analysis ToolPak

Do you analyze data with Excel? If you're not familiar, the Excel Analysis ToolPak is wildly useful. In this short demo I teach you how to enable the Analysis ToolPak and easily generate summary statistics and correlation analyses.

Make no mistake, Excel can get you very far in terms of data analysis using powerful tools like correlation, linear regression, and process behavior charts.

Also, knowledge of Excel enables you to unlock advanced analytics like machine learning.


☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData


★★★ My online data analysis courses ▶ https://school.daveondata.com


-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺    • Introduction to Business Analysis with Exc...  

💥 Learning R programming is easy for Excel users! 💥
📺    • Learning R Programming Is Easy! (Full Webi...  



Stay healthy and happy data sleuthing!