Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error
4,995 views · Published 27 June 2015 · 24:16 · Indexed 21 September 2026
Channel: excelisfun · 2015 · Education
Download files (which file shown at begin of video): https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch11/Ch11.htm Topics in this video: 1. (00:13) Introduction to Inference about Difference Between Two Population Proportions 2. (02:35) Reminder from chapter 7 of Proportions 3. (05:14) List of 4 topics for chapter 11 4. (06:00) Introduction to Sampling Distribution of Pbar 1 – Pbar 2 5. (08:46) Construct “Sampling Distribution of Single Par” (something we skipped in chapter 7) 6. (16:07) Construct Sampling Distribution of Pbar 1 – Pbar 2 (Sampling Distribution of Sample Proportions) 7. (18:57) See that Plotting all the “Sampling Distribution of Pbar1 – Pbar2” yields a somewhat symmetric distribution 8. (19:38) Prove that the Population Proportion Difference is equal to “Mean of All The Sampling Proportion Differences” 9. (21:03) Prove that the formula for “Standard Deviation / Standard Error of the Sampling Distribution of Pbar1 – Pbar2” works
