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: [ Ссылка ]


★★★ My online data analysis courses ▶ [ Ссылка ]


-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
💻 Get the Excel workbook & Notepad file for this video:
[ Ссылка ]


💥 Learning R programming is easy! 💥
Conduct powerful cluster analyses with R:
📺 [ Ссылка ]


💻 Example of a scree plot for choosing the number of clusters:
[ Ссылка ]


-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 [ Ссылка ]



Stay healthy and happy data sleuthing!

#KMeansClusterAnalysisWithExcel #KMeansClusterAnalysis #ClusterAnalysis #KMeans

свернуть