From the course: Picking the Right Chart for Your Data
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Distribution: Beyond histograms - Microsoft Excel Tutorial
From the course: Picking the Right Chart for Your Data
Distribution: Beyond histograms
- [Instructor] Distribution diagrams come in different flavors beyond the histogram, of course. You can create something like this violin plot, which is a lot like its own little histogram or bell curve, but it's filled in and it occupies both sides of an access line. And, as you can see, each individual violin plot, in this case, is like a histogram within a histogram. You can imagine where the overall bell curve would be for this overall distribution, but in addition, for each bin, we're seeing the distribution of data within that bin. Now that's powerful. Maybe it's more detail than you need for your qwhy, or maybe it's just what the doctor ordered. It depends on your data, your audience, et cetera. The box plot, or box and whiskers, is pretty similar in some ways to the violin plot, in that it can show a nice range of data. In this data set, we can see how large the group is, what the median value is, as well as the top…
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.
Contents
-
-
-
-
Chart categories2m 19s
-
(Locked)
Comparisons: Bars and columns3m 44s
-
(Locked)
Comparisons: Beyond bars5m 49s
-
(Locked)
Trends: Line charts2m 45s
-
(Locked)
Trends: Beyond the line5m 19s
-
(Locked)
Proportions: Pie charts and more3m 48s
-
(Locked)
Proportions: Beyond the circle4m 1s
-
(Locked)
Relationships: Correlation5m 8s
-
(Locked)
Relationships: Hierarchical and network3m 25s
-
(Locked)
Relationships: Flow3m 3s
-
(Locked)
Distribution: Histograms2m 8s
-
(Locked)
Distribution: Beyond histograms5m 1s
-
(Locked)
Deviation4m 40s
-
(Locked)
Geographic5m 25s
-
-
-