Calculating the Sample Size with a Finite Population in Excel
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2024
- This video demonstrates how to calculate the sample size with a finite population using Microsoft Excel. Variables used in the sample size equation include the confidence level, population proportion, confidence interval (margin of error) and the population size.
Great video providing step-by-step instructions on how to calculate the sample size with a finite population!
For those who kept having #VALUE ERRORS, make sure you are using [comma] (,) and [dot] not (.) when you add your values to C3 and C4 fields
This was a really clear demonstration of a complicated calculation! Thanks!
Good evening Dr. Todd, I found you video very educational. The week six video discussed calculating the sample size needed to give a particular margin of error for a particular confidence level. In the video you gave a sample proportion, and demonstrated how to find a confidence interval for the population proportion.
Although I use Excel almost every day, I don't typically work with formulas in Excel. Thus, I didn't realize that this software can be used for stats work to this extent. This is a very useful video that gives step-by-step detail regarding the calculation of the sample size in Excel.
I have been a big fan of Excel for years. However, I have not become very adept at utilizing formulas yet. I am excited to see how easy it is in this way and look forward to trying to become more competent at using Excel in these manners.
I haven't used excel much yet, this video walks through the process step by step.
Again, another great video from Dr. Todd explaining some statistics calculations!! Greatly needed within my doctorate studies. Looking forward to finding more videos of you explaining statistics!! Thanks …
Hi, great explanation. Do you have any idea about book that mention sampling formula of finite population?
I had never even considered using Excel for something like this. It seems like it would be very helpful. Thank you for posting this!
Thanks for posting this video! I really love learning how excel can be used for stats work.
Thank you so much this was very helpful and easy to understand
Nice video thank you, Please is there any reference paper or book chapter so that this formula could be cite in a research paper ?
Interesting how EXCEL is a useful tool in sampling. Will have to practice for future purposes.
Hey, Dr. Todd, may i know where do you get the source of the calculation? Thanks!
Hello Dr. Todd, thank you for the video.
You're welcome!
Thank you, Todd! Very clear video, it helped me a lot!
Sir how to calculate with given population size, tolerable error, expected error and confidence level
very good video. who has proposed this formula?
can someone explain the law of deminishing returns ? why as i increase my population size (beyond a specific point) the sample size stops increasing ?
Good information for statistical sample calculations and use of Excel.
Hello Todd, great video! I was able to follow and repeat your results. My question is why does the sample size increase when the population is below 100 while all other variables are constant? What am I doing wrong?
Thanks for posting a clear video. Do you have a good reference for the equation used?
Have you made a recent video? Some things have changed, an updated version would be good!
Hello! I'm confused, so the formula used for calculating the sample size is called "Finite Population Sampling"?
Your videos are amazing ❤
what is the name of this formula please?
Hi Dr. Grande. Your video was exceptionally helpful. I want to use it in a manuscript. However, I need a reference. Could you please write a reference so that I can cite this formula in a manuscript? Thanks in advance.
hi everyone grate video. How can I cite the the formular You Just used Dr. Todd
How to calculate when there is just one group of the population need to access. like Key factors affecting people with physical disability in participation in sports and physical activity in Tower Hamlet Area in London. So, how I will calculate the sample size for this study?
Great video, could you please elaborate further: who to guess for P (like in your case you've chosen 0.5?) and also what do you mean by population size? (in your case 2500?) does it mean if I am running a trial at a clinic that would be the monthly, weekly or annual clinic population? A bit confused and will thank you if you simplify that.
If I have 5 groups with different number of populations and have a total population of 2500. Once I get the sample(484) for the entire population(2500) could I take the proportion of each group and multiply it by the sample size to determine the number per group I want to sample.
great video and very educative. Is the population sample the overall population for the study area? i mean if i want to evaluate the effects of rainfall to malaria in a given place. would i get the population sample size from the study area. say 50,000 people. it still applies right?
I'd like to at least have a little bit of knowledge about how to work with the different computer programs so this video was a helpful glimpse at how to perform statistical function on Excel.
Dear Sir, Thanks for lovely video of leaning but i have one question please reply to me. who is the author of this formula. please share send the referenced link. thanks again
Saunders et al 2009
formula called Cochran
Step by step and over the cliff we go. Yet another clip from a statistician who expects everyone to now what he did when the video cuts the figures out. Well done. What's the point of a novice being here?
What is the name of the formula used?
Dr. It's a good video to calculate the sample. But would you inform the creator of this formula or reference
do you have a video that talks about finding the p value?
Does this help? th-cam.com/video/1OzxdEScs3U/w-d-xo.html
Very Nice!.. though this correction factor vary a little..
Why p =.5 but not .05?
thank you! would be awesome if we could download your excel file too. :)
Where to get p value?
The % of the population you expect to have the characteristic of your interest. Use 50% (0.5) if you are not sure.
Thank you
THANK YOU!!!!
THanks Doc
How may I contact you, Dr?
Thanks doc
You're welcome, thanks for watching -
Hello Dr. Todd, How can I calculate the mentioned specification with the 200 population?