Excel Statistical Analysis - Cross Tabulation, Visualizations, and Logical Tests, Simpson’s Paradox

Dive into advanced Excel statistical analysis techniques in this comprehensive 33-minute tutorial. Master cross tabulation using PivotTables, create appropriate visualizations, and understand AND logical tests. Explore the concept of Simpson's Paradox and its impact on data interpretation. Learn to group numerical data, build clustered and stacked column charts, and calculate percentage frequencies. Practice applying these skills with real-world examples, and discover how to effectively present your findings through custom formatting and page setup. Gain valuable insights into data relationships and improve your ability to draw accurate conclusions from complex datasets.

) Introduction.
) Data Set and Variables Used for Cross Tabulation.
) What is a Cross Tabulation Report, also known as a “Cross Tab”?.
) What is an AND Logical Test?.
) How an AND Logical Test works against a Table with Records and Fields.
) Determining Number of Classes and Class Width for Grouping Numbers into Counting Categories.
) Build Cross Tabulated Report with Quantitative and Categorical Data.
) What to do if PivotTable Field List does not show up.
) Three Amazing Parts to a Cross Tabulated Report.
) See Relationship Between Two Variables Based on the Count (Frequency).
) Visualize Cross Tab Report with 1) Clustered Column Chart (Emphasis Legend Variable) or Stacked Column Chart (Emphasis Horizontal Axis Variable).
) Build Clustered Column Chart.
) Copy Chart with keyboard: Ctrl + D.
) Difference Between Clustered Column Chart and Stacked Column Chart.
) Create % Frequency Cross Tab Report.
) PivotTable, Show Values As, % of Grand Total Calculation.
) Custom Number Formatting to hide zero values for % of Grand Total Calculation.
) Page Setup to Print Out Two Pages from One Worksheet.
) Practice Cross Tab and Visualizations for the Variables Age and Boomerang Flight Range.
) Simpson’s Paradox and why it is important for understanding why people can claim different conclusions based in the same data!.
) Conclusions.
) Closing and Video Links.