Join Conrad Carlberg for an in-depth discussion in this video Exercise files, part of Data Reduction Techniques Using Excel and R: Business Analytics Deep Dive.
- [Instructor] If you access to the exercise files for this course, you can download them to your desktop. The exercise files folder contains a subfolder for each chapter, and each chapter folder contains a subfolder for each video that has exercises files. The files are there for you to use in following any instructions or suggestions in the videos. In some cases, the video will use an exercise file that I don't supply.
A good example is a dataset that's included in the R statistical application. If you're viewing this course on a mobile device, a set-top device or your membership doesn't provide access to the exercise files, that's okay. I encourage you to still follow along as we go through the course. Now let's get started.
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