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

preview_player
Показать описание
Topics in this video:
1. (00:12) Chapter explanation
2. (01:57) Discussion about Samples, Point Estimates and Sampling Error
3. (03:50) Why take samples rather than use all the population items?
4. (05:10) What do we use samples for? Answering Research Questions!
5. (06:01) Learn about Sample Population and Target Population
6. (08:58) What is a Frame? Frame = List of items in population
7. (10:58) Simple Random Sampling: use when you have a finite population where you can create a frame.
8. (11:33) Random Sampling: use when you have a finite population or on-going process where you cannot create a frame. Two important points must hold true before selecting n items in a random way: 1) All items must be from same population (Samples = Target) and 2) Items must be selected Independently (without bias)
9. (13:25) Define Simple Random Sampling and do a few tests in Excel to prove to ourselves that the definition makes sense. We will look at one sample and the sampling error, then we will list all possible samples and then calculate the probability that we could get any one sample.
10. (16:20) Use VLOOKUP to list all numbers for all possible samples
11. (17:58) Calculate Sample Mean, Xbar, for every one of the possible samples
12. (18:18) Calculate probability of each sample (part of definition of Simple Random Sample)
13. (19:30) Introduction to RAND function
14. (20:36) Create Simple Random Sample using RAND Excel function (0 greater than or equal to 15 digit Number less than 1), the Sort Feature and Copy & Paste.
15. (23:12) Create Simple Random Sample using RAND, SMALL and VLOOKUPO Excel functions
16. (25:53) Conclusion
Рекомендации по теме
Комментарии
Автор

Excel 2013 Statistical Analysis #43: Simple Random Sampling in Excel: Process & Theory
Topics in this video:
1. (00:12) Chapter explanation
2. (01:57) Discussion about Samples, Point Estimates and Sampling Error
3. (03:50) Why take samples rather than use all the population items?
4. (05:10) What do we use samples for? Answering Research Questions!
5. (06:01) Learn about Sample Population and Target Population
6. (08:58) What is a Frame? Frame = List of items in population
7. (10:58) Simple Random Sampling: use when you have a finite population where you can create a frame.
8. (11:33) Random Sampling: use when you have a finite population or on-going process where you cannot create a frame. Two important points must hold true before selecting n items in a random way: 1) All items must be from same population (Samples = Target) and 2) Items must be selected Independently (without bias)
9. (13:25) Define Simple Random Sampling and do a few tests in Excel to prove to ourselves that the definition makes sense. We will look at one sample and the sampling error, then we will list all possible samples and then calculate the probability that we could get any one sample.
10. (16:20) Use VLOOKUP to list all numbers for all possible samples
11. (17:58) Calculate Sample Mean, Xbar, for every one of the possible samples
12. (18:18) Calculate probability of each sample (part of definition of Simple Random Sample)
13. (19:30) Introduction to RAND function
14. (20:36) Create Simple Random Sample using RAND Excel function (0 greater than or equal to 15 digit Number less than 1), the Sort Feature and Copy & Paste.
15. (23:12) Create Simple Random Sample using RAND, SMALL and VLOOKUPO Excel functions
16. (25:53) Conclusion

excelisfun
Автор

I really appreciate these videos. I have learned so much. I love the energy you put into it!

nikih
Автор

Thank you Mike..I am a big fan of yours..thanks for making excel fun to learn

akhilmohansamantaray
Автор

thanks for the video, I would like to know how we can calculate X if the probability is given

muralikrishnapolipallivenk
Автор

If the way to get a sample that is representative of a population is to draw the random sample, why do we need to be concerned with sampling error?

latesq