+ Reply to Thread
Results 1 to 3 of 3

Calculating Percentiles based on known data

  1. #1
    Registered User
    Join Date
    06-27-2008
    Location
    TX
    Posts
    9

    Calculating Percentiles based on known data

    Is there a function in Excel that would calculate the 85th & 90th percentiles based on the 50th & 75th percentiles.

    Thanks
    Last edited by Dooldeniya; 07-15-2009 at 05:14 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Calculating Percentiles based on known data

    If you assume the data is exactly Gaussian, the 50th percentile is the mean, and the 75th (or any other) percentile can be used to calculate the deviation:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-27-2008
    Location
    TX
    Posts
    9

    Re: Calculating Percentiles based on known data

    SHG -
    Any explanation why it works the way it does?

+ 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