Completed
) Visualize Cross Tab Report with 1) Clustered Column Chart (Emphasis Legend Variable) or Stacked Column Chart (Emphasis Horizontal Axis Variable)
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - Cross Tabulation, Visualizations, and Logical Tests, Simpson’s Paradox
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Data Set and Variables Used for Cross Tabulation
- 3 ) What is a Cross Tabulation Report, also known as a “Cross Tab”?
- 4 ) What is an AND Logical Test?
- 5 ) How an AND Logical Test works against a Table with Records and Fields
- 6 ) Determining Number of Classes and Class Width for Grouping Numbers into Counting Categories
- 7 ) Build Cross Tabulated Report with Quantitative and Categorical Data
- 8 ) What to do if PivotTable Field List does not show up
- 9 ) Three Amazing Parts to a Cross Tabulated Report
- 10 ) See Relationship Between Two Variables Based on the Count (Frequency)
- 11 ) Visualize Cross Tab Report with 1) Clustered Column Chart (Emphasis Legend Variable) or Stacked Column Chart (Emphasis Horizontal Axis Variable)
- 12 ) Build Clustered Column Chart
- 13 ) Copy Chart with keyboard: Ctrl + D
- 14 ) Difference Between Clustered Column Chart and Stacked Column Chart
- 15 ) Create % Frequency Cross Tab Report
- 16 ) PivotTable, Show Values As, % of Grand Total Calculation
- 17 ) Custom Number Formatting to hide zero values for % of Grand Total Calculation
- 18 ) Page Setup to Print Out Two Pages from One Worksheet
- 19 ) Practice Cross Tab and Visualizations for the Variables Age and Boomerang Flight Range
- 20 ) Simpson’s Paradox and why it is important for understanding why people can claim different conclusions based in the same data!
- 21 ) Conclusions
- 22 ) Closing and Video Links
