Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Business Analytics: Data Reduction Techniques Using Excel and R

via LinkedIn Learning

Overview

Learn how to carry out cluster analysis and principal components analysis using R, the open-source statistical computing software.

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.

Syllabus

Introduction
  • Welcome
  • What you should know before watching this course
  • Exercise files
1. Problems Raised by Massive Amounts of Data
  • Observation overkill
  • Rationale for clustering
  • Rationale for PCA
2. An Overview of Principal Components Analysis
  • Using Excel to extract principal components
  • Rotating factors
  • Using R to extract principal components
3. An Overview of Cluster Analysis
  • ANOVA and MANOVA reviewed
  • Causation and probability
  • Multivariate nature of clustering
  • Using R for cluster analysis
  • Using Excel for cluster analysis
  • Setting up confusion tables in Excel
4. Putting It Together: Using Cluster Anaysis and Factor Analysis in Concert
  • Clusters and factors
  • Pivot table analysis
Conclusion
  • Next steps

Taught by

Conrad Carlberg

Reviews

Start your review of Business Analytics: Data Reduction Techniques Using Excel and R

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.