Join Conrad Carlberg for an in-depth discussion in this video What you should know before watching this course, part of Business Analytics: Data Reduction Techniques Using Excel and R.
- [Instructor] You will find it helpful to have a basic grounding in the use of Microsoft Excel and the R statistical application. No advanced techniques are required, but it will be useful to know how to get around in the application, how to copy and paste, and so on. You will need to have the freeware R application installed on your computer if you intend to follow along with all the exercises. You can find instructions on installing R in R for Excel Users.
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