Channel: ExcelIsFun

Category: Education

Tags: business statistical analysisdefinition of simple random samplingdata analysissampling distribution of sample meanssamplingxlookup functionesa 36highline collegeexcel statisticsmike girvinsimple random samplingexcel rand functionmicrosoft 365 excelsampling distribution of xbarbusn 210list all possible samplesmike excelisfun girvinstatistical analysischapter 6avearge functionexcelisfunexcel statistical analysis

Description: Download Excel File: excelisfun.net/files/Ch07-ESA.xlsm PDF notes file: 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