Lynda – Up and Running with Excel Cluster Analysis-0daytown

Lynda – Up and Running with Excel Cluster Analysis | 146MB

Duration: 1h 10m | Video: AVC (.mp4) 1280×720 15fps | Audio: AAC 44.1KHz 1chGenre: eLearning | Level: Advanced | Language: English

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.

Topics include:

* 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

Download rapidgator
http://rg.to/file/ff5d60bf0983f129973f79681c1c91c6/LcUaRExcelCluster.rar.html

Download uploaded
http://uploaded.net/file/fbvbaya8/LcUaRExcelCluster.rar

Download firedrive
http://www.firedrive.com/file/5E66147A60E52F56

Download 百度云
链接: http://pan.baidu.com/s/1sjsJEm5 密码: ujzy

转载请注明：0daytown » Lynda – Up and Running with Excel Cluster Analysis