Learn everything about Analytics

Up and Running with Excel Cluster Analysis – Lynda

Lynda
0-6 Month Online
Intermediate Contact Institute
Online Business Intelligence
Online Self Paced 982
DescriptionProgram StructureToolsContact

Learn how to use Excel’s built-in data management and computation functions to identify clusters of data points—with little or no VBA! You will be shown how to set up a worksheet for cluster analysis, create formulas that identify the closest focal point (centroid) for each row, and analyze your results in an Excel table or XY scatter chart.

Topics:

  • What is clustering?
  • Setting up your Excel table
  • Creating a list of centroids
  • Identifying the closest centroid
  • Updating centroids using averages
  • Automating updates with macros
  • Analyzing your data in Excel
  • Visualizing data in a chart

Fees: – INR 15, 00 (assuming $ = INR 60)

Duration:

1 Hour 9 Minutes

  • Excel
Name :
Email :
Contact Number :
Message :
Code :

This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved
Join 100000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.

Join 100000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.