Calculating the Sample Size with a Finite Population in Excel
HTML-код
- Опубликовано: 22 авг 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!
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.
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.
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.
This was a really clear demonstration of a complicated calculation! Thanks!
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
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 …
I haven't used excel much yet, this video walks through the process step by step.
Hi, great explanation. Do you have any idea about book that mention sampling formula of finite population?
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?
Thank you so much this was very helpful and easy to understand
I had never even considered using Excel for something like this. It seems like it would be very helpful. Thank you for posting this!
Have you made a recent video? Some things have changed, an updated version would be good!
very good video. who has proposed this formula?
Nice video thank you, Please is there any reference paper or book chapter so that this formula could be cite in a research paper ?
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
Interesting how EXCEL is a useful tool in sampling. Will have to practice for future purposes.
Thanks for posting this video! I really love learning how excel can be used for stats work.
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?
Sir how to calculate with given population size, tolerable error, expected error and confidence level
Your videos are amazing ❤
Good information for statistical sample calculations and use of Excel.
THANK YOU!!!!
Thank you, Todd! Very clear video, it helped me a lot!
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.
Hello Dr. Todd, thank you for the video.
You're welcome!
can someone explain the law of deminishing returns ? why as i increase my population size (beyond a specific point) the sample size stops increasing ?
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.
Thank you
Dr. It's a good video to calculate the sample. But would you inform the creator of this formula or reference
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?
what is the name of this formula please?
Hey, Dr. Todd, may i know where do you get the source of the calculation? Thanks!
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?
Hello! I'm confused, so the formula used for calculating the sample size is called "Finite Population Sampling"?
thank you! would be awesome if we could download your excel file too. :)
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
Very Nice!.. though this correction factor vary a little..
What is the name of the formula used?
THanks Doc
Why p =.5 but not .05?
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.
do you have a video that talks about finding the p value?
Does this help? ruclips.net/video/1OzxdEScs3U/видео.html
Thanks doc
You're welcome, thanks for watching -
How may I contact you, Dr?
Hello Dr. Todd, How can I calculate the mentioned specification with the 200 population?