Download Excel File: https://excelisfun.net/files/Ch07-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch07-ESA.pdf
Learn about Sampling & Sampling Distribution of Sample Means (Xbar).
Topics:
1. (00:00) Introduction
2. (24:36) Chapter 7 Content
3. (00:58) Where we have come from, this chapter and next chapter
4. (02:13) Population, Sample and Sample Error, First Look
5. (03:22) Sampling Distribution of Xbar is model to help determine is an Xbar is reasonable
6. (04:06) Why do we take and need Samples?
7. (06:17) Sampled Population and Target Population
8. (09:15) What is a Frame?
9. (11:12) Sampling Methods: Simple Random Sampling and Random Sampling
10. (13:33) Definition of Simple Random Sampling
11. (14:13) Excel: Create a sample and consider Sampling Error
12. (15:44) Excel: List every possible sample and calculate all Sample Means (Xbars). See XLOOKUP and AVEARGE functions
13. (18:49) Understanding Definition of Simple Random Sampling’s requirement that each element selected in sample must have same probability (uniform distribution)
14. (19:40) Excel RAND function
15. (20:37) Excel: Simple Random Sampling with RAND function and Sort feature
16. (23:33) Summary of video
17. (23:56) Closing, Next Video and Video Links