->
Lynda - Learning Excel Cluster Analysis - 165438
Lynda - Learning Excel Cluster Analysis
Learn how to use Excel's built-in data management and computation functions to identify clusters of data points—with little or no VBA! Author Curt Frye shows you 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. Members who don't mind recording macros or writing VBA code can learn how to automate some parts of the procedure.


Table of Contents

  • Introduction
  • 1. Introducing Cluster Analysis
  • 2. Building a Cluster Analysis Worksheet
  • 3. Analyzing and Visualizing Cluster Data
  • Conclusion
  • Lynda - Learning Excel Cluster Analysis


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss