Главная
Study mode:
on
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
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Visualization #Mathematics #Statistics & Probability #Statistical Analysis #Data Analysis #Spreadsheets #PivotTables
0:00 / 0:00
1 of 22

) Introduction