+ Reply to Thread
Results 1 to 2 of 2

More stats than excel

  1. #1
    Registered User
    Join Date
    09-16-2009
    Location
    NW Arkansas
    MS-Off Ver
    Excel 2007
    Posts
    24

    Question More stats than excel

    Looking for a way to predict frequency of a range of values based on a mean and standard deviation.

    For example:

    I know that my mean is 160 and my standard deviation is 20 and I know that ~68% of my values will fall between 140 and 180 but how can I predict how many values will fall between 140 to 150? or 200 to 250, or etc.

    Thanks.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: More stats than excel

    If I understand my stats correctly (and I tested this with values of 180 and 140 and got ~68%, you can use =NORMDIST(250,160,20,1)-NORMDIST(200,160,20,1)

+ 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