Excel Statistical Analysis - Cross Tabulation, Visualizations, and Logical Tests, Simpson’s Paradox
Offered By: ExcelIsFun via YouTube
Course Description
Overview
Syllabus
) 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.
Taught by
ExcelIsFun
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard