+ Reply to Thread
Results 1 to 2 of 2

Standard deviation calculations with excel

  1. #1
    Registered User
    Join Date
    12-18-2007
    Posts
    1

    Standard deviation calculations with excel

    Hi,

    Would someone be able to help me with standard deviation within excel? I have used the formula =STDEV(number one, number two...etc). I think the problem is that my data is not a normal distribution, thus the incorrect standard deviation value. But I need to some how calculate standard deviation? Is there a way that I can with excel? I have over 20 000 data elements, thus making it harder to work out. Could someone please suggest some ideas that I could possibly implement to help correctly calculate standard deviation?

  2. #2
    Registered User
    Join Date
    06-23-2007
    Posts
    41
    Standard deviation of a set of numbers is independent of the type of distribution. See:
    http://en.wikipedia.org/wiki/Standard_deviation
    In excel you have two functions for this:
    =STDEV for a sample of a bigger population or =STDEVP() for the whole population.
    If you are then:
    Useful links


    Enjoy, Duchbeer.

+ 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