From the course: Machine Learning and AI Foundations: Clustering and Association
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Traffic Light feature in Excel
From the course: Machine Learning and AI Foundations: Clustering and Association
Traffic Light feature in Excel
- [Instructor] I'm in the same data file ready for cluster with categorical variables. In addition to reporting on dollar amounts and where the clusters live and all kinds of other information about them, at some point in the report you are going to want to make it clear how the clusters arose to be. You'll want to take the same variables that you fed into the clustering algorithm and report on those. What I'm about to show you is my favorite way to do that. I'm going to go to Analyze, Compare Means, Means; and I'm going to grab the ratio variables that I used. Even if you dropped a couple of the ratio variables, you may want to include them here. You may want to try it both with and without. For instance, in some of the clustering solutions we excluded software and streaming 'cause it wasn't showing a difference. I'll tend to drag them into the report anyway, because this represents the different product lines in my organization presumably. If I don't have those variables, they're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.