Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Paradox

preview_player
Показать описание
Cross Tabulation & Charts For Two Variables, Simpsons Paradox
Topics in this video shows how to create Cross Tabulated Tables, Clustered Column Chart, Stacked Column Chart,100% Stacked Column Chart with PivotTables:
1. (00:09) Explain meaning and uses for Cross Tabulation Tables, Clustered Column Chart, Stacked Column Chart and 100% Stacked Column Chart
2. (04:02) Use PivotTable to create Cross Tabulated Table for a Categorical and Quantitative Variable (Age and Payment Method for a Sales transaction)
3. (04:17) Group Whole Number (age)
4. (06:22) Column Chart Options in Excel
5. (06:48) Clustered Column Chart to emphasize variable in Legend (Payment Method)
6. (08:27) Stacked Column Chart to emphasize variable in Horizontal Axis (Grouped Age Category)
7. (09:14) 100% Stacked Column Chart to emphasize the percentages.
8. (10:00) Use PivotTable to create Cross Tabulated Table for Two Categorical Variables and see that Cross Tabulation are actually a three-in-one table that show: 1) Cross Tab, 2) Frequency Distribution for the Row Variable and 3) Frequency Distribution for the Column Variable
9. (12:10) Simpson’s Paradox: Revealing a Hidden Variable in two sub-Cross Tabulation PivotTables may show a reverse conclusion as compared to the aggregated Cross Tabulation.
  1. excelisfun
  2. Excel 2013
  3. Statistical Analysis
  4. Excel Statistics
  5. Highline College
  6. Business and Economic Statistical Analysis
Рекомендации по теме
Excel 2013 Statistical 0:18:37

Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Para...

Excel 2013 Statistical 0:25:27

Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)

Excel 2013 Statistical 0:11:49

Excel 2013 Statistical Analysis #17: Weighted Mean & SUMPRODUCT Function & Accounting Exampl...

Excel 2013 Statistical 2:22:43

Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)

Excel 2013 Statistical 0:13:05

Excel 2013 Statistical Analysis #14: VLOOKUP to Add New Field To Table & Create Cross Tabulation

Excel 2013 Statistical 0:26:57

Excel 2013 Statistical Analysis #43: Simple Random Sampling in Excel: Process & Theory

Excel 2013 Statistical 0:11:04

Excel 2013 Statistical Analysis #45: Sampling Distribution of Pbar (Binomial Sample Proportion)

Excel 2013 Statistical 0:41:36

Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable

ATS Friendly Resume 0:16:05

ATS Friendly Resume for Data Analyst Fresher | Best CV Format 2024 | CV Format for Job

Excel 2013 Statistical 0:07:22

Excel 2013 Statistical Analysis #13: Scatter Chart & Trendline, X Y Data, 2 Quantitative Variabl...

Excel 2013 Statistical 0:15:48

Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable &...

Excel 2013 Statistical 0:09:01

Excel 2013 Statistical Analysis #37: Introduction to Continuous Probability Distributions

Excel 2013 Statistical 0:07:01

Excel 2013 Statistical Analysis #52: Determine Sample Size for Sample Mean & Sample Proportion

Excel 2013 Statistical 0:09:02

Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year

Excel 2013 Statistical 0:33:18

Excel 2013 Statistical Analysis #28: Multiplication Law of Probability AND Events (16 Examples)

Excel 2013 Statistical 0:19:22

Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient

Excel 2013 Statistical 0:31:07

Excel 2013 Statistical Analysis #25: Probability Basics: Sample Points, Events & Event Probabili...

Excel 2013 Statistical 0:07:02

Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions

Excel 2013 Statistical 0:30:11

Excel 2013 Statistical Analysis #72: Chi-Square Test For 2 or More Population Proportions (Formulas)

Excel 2013 Statistical 0:24:16

Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Err...

Excel 2013 Statistical 0:23:45

Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function

Excel 2013 Statistical 0:14:29

Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line

Excel 2013 Statistical 0:37:51

Excel 2013 Statistical Analysis #33: Binomial Probability Distributions: Tables, Charts, Functions

Excel 2013 Statistical 0:16:40

Excel 2013 Statistical Analysis #30: Bayes’ Theorem to Calculate Posterior Probabilities

Комментарии
Автор

Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Paradox
Cross Tabulation & Charts For Two Variables, Simpsons Paradox
Topics in this video shows how to create Cross Tabulated Tables, Clustered Column Chart, Stacked Column Chart, 100% Stacked Column Chart with PivotTables:
1. (00:09) Explain meaning and uses for Cross Tabulation Tables, Clustered Column Chart, Stacked Column Chart and 100% Stacked Column Chart
2. (04:02) Use PivotTable to create Cross Tabulated Table for a Categorical and Quantitative Variable (Age and Payment Method for a Sales transaction)
3. (04:17) Group Whole Number (age)
4. (06:22) Column Chart Options in Excel
5. (06:48) Clustered Column Chart to emphasize variable in Legend (Payment Method)
6. (08:27) Stacked Column Chart to emphasize variable in Horizontal  Axis (Grouped Age Category)
7. (09:14) 100% Stacked Column Chart to emphasize the percentages.
8. (10:00) Use PivotTable to create Cross Tabulated Table for Two Categorical Variables and see that Cross Tabulation are actually a three-in-one table that show: 1) Cross Tab, 2) Frequency Distribution for the Row Variable and 3) Frequency Distribution for the Column Variable
9. (12:10) Simpson’s Paradox: Revealing a Hidden Variable in two sub-Cross Tabulation PivotTables may show a reverse conclusion as compared to the aggregated Cross Tabulation.

excelisfun
Автор

I'm really dumb at IT and this video helps a lot. Keep it coming

ainatiyaazmi
Автор

hey! you voice is exactly like Ross in Friends Sitcom

Jitendrakumar-dung
Автор

Oh this Simson paradox confused me for a while :)

tomash
Автор

thanks for the course. I am shocked that it is free

Eshtele
Автор

How can I create a range that the upper number is not repeated on the next range.
Ex. 1-5 then next is 6-10

rubiedelacruz
Автор

What's the point about Simpson's Paradox on Business Analysis? Is it relevant?

GabrielCamilo