Transcript
Chapter 5: How Variables ClassifyJointly: Contingency Tables
Outline
• Binomial Distribution (demo)• One-Way Pivot Tables• Two-Way Pivot Tables• Cross-Tabulation
Binomial / Bernoulli Distribution
1654-1705
Binomial Formula
Excel Binomial Distribution
Excel Binomial Distribution
Cell Phone Quality ControlYour company will be satisfied if only 1% of its phones fail to establish a connection with a cell tower that’s within reach.
Goal Sample Prediction
1000 50 ?
1% 4% ?
10 2 ?
Understanding One-Way Pivot Tables
Using the BINOM.DIST() Function
Understanding Two-Way Pivot Tables
CategoricalProportions
Z-Test Proportions
A chi-square test for equality of two proportions is exactly the same thing as a z-test.
Chi-Square vs. Z-Test Proporations