+ Reply to Thread
Results 1 to 3 of 3

sample size formula

  1. #1
    Registered User
    Join Date
    04-20-2012
    Location
    Bournemouth
    MS-Off Ver
    Excel 2007
    Posts
    34

    sample size formula

    Hi all,

    Looking for some help with building a formula for calculating samples sizes.

    I want a confidence level of 95% and a confidence interval of +/-4.

    My population on the current workbook is 19984.

    Help would be appreciated.

    Thanks,

    Scott

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: sample size formula

    Without knowing the specific type of distribution of your data, or the standard deviation if it's mathematical data, I'm not seeing an applicable excel function. Furthermore, are you replacing samples, etc? However, I googled it for you and found:

    http://www.surveysystem.com/sscalc.htm#one

    583

    Additionally, I found Slovin's Formula:
    http://www.ehow.com/way_5475547_slov...echniques.html

    n = N / (1 + Ne^2)

    n = Number of samples
    N = Total population
    e = Error tolerance

    Also, here's a wonderful list of equations from some random PDF hit:
    http://www.uky.edu/~jmlhot2/courses/...la%20Sheet.pdf

    I assume you're good enough with excel to program in the equations yourself as needed. But that should highlight the equations to use.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  3. #3
    Registered User
    Join Date
    04-20-2012
    Location
    Bournemouth
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: sample size formula

    Thanks for your help. Looking at the http://www.surveysystem.com/sscalc.htm#one

    What's the best way to lay this out in a formula? As I tried a few different methods and seemingly fail everytime.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1