Completed
) Introduction
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
