Sample Size Calculator with Excel

This post explains how to calculate sample size with MS Excel.

Determining sample size is a very important issue because samples that are too large may waste time, resources and money, while samples that are too small may lead to inaccurate results. Hence, it is required to determine the minimum recommended size of your survey. If you interview this many people you'll get results that reflect the target population as precisely as needed.

Sample Size Calculator with Excel

Enter Population Size

Total number of individuals about which sample size calculation is required.

Enter Sample Size

Number of individuals required to respond to respond to achieve the required level of accuracy.

Download Sample Size Calculator Template for Excel

Sample Size Formula

n= t² x p(1-p)
m²

n : minimum required sample size
t : confidence level at x% level of significance
p : estimate of the proportion of people falling into the group in which you are interested
m : margin of error

Margin of error

Margin of error or Confidence interval is usually reported in opinion poll results. It is a 95 percent confidence interval i.e. for every 20 times you repeat this poll, statistics say that one time you'll get an answer that is completely off the wall. For example: the poll had a margin of error of plus or minus three percentage points (3%) and 51% percent of your sample picked an answer you can be "sure" that if you had asked the question of the entire relevant population between 48% (51-3) and 54% (51+3) would have picked that answer.

Download Margin of Error Calculator Template for Excel

Spread the Word!
Share Share Tweet

About Author:
Deepanshu Bhalla

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.

While I love having friends who agree, I only learn from those who don't
Let's Get Connected Email LinkedIn

11 Responses to "Sample Size Calculator with Excel"

UnknownMarch 23, 2014 at 11:19 PM
Excellent and decent post. I found this much informative, as to what I was exactly searching for. Thanks for such post and keep it up.

Arianne
www.gofastek.com
UnknownOctober 19, 2015 at 8:01 AM
I have a mean value of a parameter and a standard deviation with a sample size of 6: if we assume a normal distribution then how do we calculate the expected mean from a ample size of 12.?
jenniisthemencaseNovember 5, 2015 at 7:51 PM
Is there a way to generate a comment based on the sample size of the given data?__
UnknownDecember 29, 2015 at 4:53 AM
how can I get a sample size for populations of 1578
UnknownAugust 2, 2016 at 2:41 PM
You have done a fantastic Job.
UnknownSeptember 24, 2016 at 4:27 PM
Nice blog do carry on
Mueeid KhanOctober 29, 2017 at 5:06 AM
There are now widely used in companies and universities for calculation processes. With the advent of internet, these calculators have further been modified to be made available in online version.guarantor loans
w3webschoolOctober 13, 2018 at 8:00 AM
Nice post By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision.
Web Design Training
sharingpostingkingNovember 10, 2018 at 12:58 AM
This comment has been removed by the author.
SarahMarch 21, 2019 at 3:34 AM
Skipping classes is a major no-no. Taking notes will enable you to focus and it fills in as a supportive reference point, when you're concentrating later.
calculus