Calculating the Sample Size with a Finite Population in Excel

[@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.

[@gurlygurl3266]

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

[@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.

[@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 …

[@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!

[@karaannsullivan2363]

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

[@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.

[@samall9080]

Your videos are amazing ❤

[@abelwondimagegnehu1106]

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

[@anggamulyawan5648]

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

[@JulioGuilger]

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

[@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

[@VishnuSingh-mk4ei]

Hello Dr. Todd, thank you for the video.

[@DrGrande]

You're welcome!

[@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 ?

[@michaelquist8468]

Good information for statistical sample calculations and use of Excel.

[@jamiemccracken3942]

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

[@kidskidscartoontv]

very good video. who has proposed this formula?

[@ninish5257]

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

[@theresarodriguez1488]

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

[@rojinadesar7923]

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

[@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?

[@atarodatarod1836]

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

[@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.

[@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?

[@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 ?

[@imiespina5997]

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

[@girishhavale2483]

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

[@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.

[@lungisamatwana6262]

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

[@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?

[@chrismar2462]

THANK YOU!!!!

[@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?

[@lorainerodrigo6383]

What is the name of the formula used?

[@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?

[@jaynajwa0007]

Thank you

[@andresflores9204]

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

[@DrGrande]

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

[@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

[@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.

[@assefahailu4218]

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

[@GedeonMunyaneza]

How may I contact you, Dr?

[@laurencooper9076]

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

[@folarashid]

THanks Doc

[@Mark6770]

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

[@Life-pk1sq]

Why p =.5 but not .05?

[@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.

[@seyf8795]

Thanks doc

[@DrGrande]

You're welcome, thanks for watching -