Lynda - Data Reduction Techniques Using Excel and R: Business Analytics Deep Dive
Lynda - Data Reduction Techniques Using Excel and R: Business Analytics Deep Dive
Size: 145 MB | Duration: 1h 2m | Video: AVC (.mp4) 1280x720 30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Advanced | Language: English
Size: 145 MB | Duration: 1h 2m | Video: AVC (.mp4) 1280x720 30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Advanced | Language: English
With businesses having to grapple with increasing amounts of data, the need for data reduction has intensified in recent years. To make sense of an overabundance of information, you can use cluster analysis—which allows you to develop inferences about a handful of groups instead of an entire population of individuals—as well as principal components analysis, which exposes latent variables. In this course, Conrad Carlberg explains how to carry out cluster analysis and principal components analysis using Microsoft Excel, which tends to show more clearly what's going on in the analysis. Then he explains how to carry out the same analysis using R, the open-source statistical computing software, which is faster and richer in analysis options than Excel. Plus, he walks through how to merge the results of cluster analysis and factor analysis to help you break down a few underlying factors according to individuals' membership in just a few clusters.
* Reviewing the problems created by an overabundance of data
* Understanding the rationale for clustering and principal components analysis
* Using Excel to extract principal components
* Using R to extract principal components
* Using R for cluster analysis
* Using Excel for cluster analysis
* Setting up confusion tables in Excel
* Using cluster analysis and factor analysis in concert
* Understanding the rationale for clustering and principal components analysis
* Using Excel to extract principal components
* Using R to extract principal components
* Using R for cluster analysis
* Using Excel for cluster analysis
* Setting up confusion tables in Excel
* Using cluster analysis and factor analysis in concert
Lynda - Data Reduction Techniques Using Excel and R: Business Analytics Deep Dive
No mirrors below please.