Calculating the Sample Size with a Finite Population in Excel

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.

[@gurlygurl3266]

Great video providing step-by-step instructions on how to calculate the sample size with a finite population!

[@karaannsullivan2363]

This was a really clear demonstration of a complicated calculation! Thanks!

[@meimunehsumadi3597]

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 …

[@UniquelyUlysa]

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.

[@ciaralawton2959]

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.

[@jannabassette1930]

I had never even considered using Excel for something like this. It seems like it would be very helpful. Thank you for posting this!

[@anggamulyawan5648]

Hi, great explanation. Do you have any idea about book that mention sampling formula of finite population?

[@amandadonelson2471]

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.

[@jodinakamura5652]

I haven't used excel much yet, this video walks through the process step by step.

[@jonathanhoover8423]

Thanks for posting this video! I really love learning how excel can be used for stats work.

[@profirhuma]

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

[@abelwondimagegnehu1106]

Thank you so much this was very helpful and easy to understand

[@ehoumanevans4783]

Nice video thank you, Please is there any reference paper or book chapter so that this formula could be cite in a research paper ?

[@chazlee362vines4]

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?

[@nuritaydemir]

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.

[@JulioGuilger]

Thank you, Todd! Very clear video, it helped me a lot!

[@theresarodriguez1488]

Have you made a recent video? Some things have changed, an updated version would be good!

[@kidskidscartoontv]

very good video. who has proposed this formula?

[@rojinadesar7923]

Thanks for posting a clear video. Do you have a good reference for the equation used?

[@michaelquist8468]

Good information for statistical sample calculations and use of Excel.

[@lungisamatwana6262]

hi everyone grate video. How can I cite the the formular You Just used Dr. Todd

[@VishnuSingh-mk4ei]

Hello Dr. Todd, thank you for the video.

[@DrGrande]

You're welcome!

[@jamiemccracken3942]

Interesting how EXCEL is a useful tool in sampling. Will have to practice for future purposes.

[@ninish5257]

Hey, Dr. Todd, may i know where do you get the source of the calculation? Thanks!

[@profirhuma]

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.

[@samall9080]

Your videos are amazing ❤

[@girishhavale2483]

Sir how to calculate with given population size, tolerable error, expected error and confidence level

[@atarodatarod1836]

Hello Dr. Todd, How can I calculate the mentioned specification with the 200 population?

[@tanjidchowdhury4816]

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?

[@imiespina5997]

Hello! I'm confused, so the formula used for calculating the sample size is called "Finite Population Sampling"?

[@robertschlee5249]

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.

[@dinohadjiyannis3225]

can someone explain the law of deminishing returns ? why as i increase my population size (beyond a specific point) the sample size stops increasing ?

[@shirleyonyango5981]

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?

[@andypac7]

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?

[@doctorkumar]

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

[@kariminic]

Saunders et al 2009 formula called Cochran

[@assefahailu4218]

Dr. It's a good video to calculate the sample. But would you inform the creator of this formula or reference

[@laurencooper9076]

thank you! would be awesome if we could download your excel file too. :)

[@emmagilligan7912]

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.

[@kmonicapar2698]

what is the name of this formula please?

[@chrismar2462]

THANK YOU!!!!

[@jaynajwa0007]

Thank you

[@Mark6770]

Very Nice!.. though this correction factor vary a little..

[@lorainerodrigo6383]

What is the name of the formula used?

[@folarashid]

THanks Doc

[@andresflores9204]

do you have a video that talks about finding the p value?

[@DrGrande]

Does this help? kzbin.info/www/bejne/Z4DdqZd7iMimabc

[@Life-pk1sq]

Why p =.5 but not .05?

[@GedeonMunyaneza]

How may I contact you, Dr?

[@seyf8795]

Thanks doc

[@DrGrande]

You're welcome, thanks for watching -

[@nursuraya1993]

Where to get p value?

[@ChaingaZulu]

The % of the population you expect to have the characteristic of your interest. Use 50% (0.5) if you are not sure.