web analytics

Categories

LYNDA_UP_AND_RUNNING_WITH_EXCEL_CLUSTER_ANALYSIS_TUTORIAL-kEISO

Posted by on May 28th, 2014 1 Comment SCENE

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.



Shoutbox

Links to websites similar to DDLValley are prohibited and may get you banned.
Your code: