K-means Cluster Analysis With Excel - A Tutorial
Описание
In this video I will teach you how to perform a K-means cluster analysis with Excel. Cluster analysis is a wildly useful skill for ANY professional and K-means a great first clustering algorithm - no VBA code required!
Cluster analysis is used in all areas of business:
? In HR analytics for understanding similar employees
? In marketing analytics for customer segmentation
? In supply chain management to optimize logistics
The list goes on.
The great news is that you can perform K-means clustering in Excel using simple tools like VLOOKUPs and a tiny bit of Power Query.
This video is a fairly in-depth tutorial on K-means clustering, so feel free to jump around if a full tutorial experience is not what you need.
☕ 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
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
? Get the Excel workbook & Notepad file for this video:
https://github.com/DaveOnData/DataAnalysisWithExcel
? Learning R programming is easy! ?
Conduct powerful cluster analyses with R:
? https://youtu.be/MNpsyjSuR20
? Example of a scree plot for choosing the number of clusters:
https://rstudio-pubs-static.s3.amazonaws.com/476207_937ae346a91442fdb6b84c840092f441.htm #selecting-number-of-clusters
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
???? Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
? https://youtu.be/xIXymabyFIM
Stay healthy and happy data sleuthing!
#KMeansClusterAnalysisWithExcel #KMeansClusterAnalysis #ClusterAnalysis #KMeans
Рекомендуемые видео
