+ Reply to Thread
Results 1 to 3 of 3

Percentile Question

  1. #1
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Percentile Question

    Hi Guys, im not even sure this is possible but I wanted to give it a shot. Im trying to calculate the 60 percentile based on the following data.

    50 percentile - $43.61
    75 percentile - $52.02
    90 percentile - $64.22

    I dont have access to the source data so im trying to back in to the 60 percentile. Does anyone have any idea on how to do this?
    Last edited by day92; 06-22-2012 at 03:03 PM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Percentile Question

    60 percentile would equate to $46.974

    Have attached a worksheet depicting the calculation.

    Show your appreciation - Click the star icon if this post has been helpful
    Attached Files Attached Files

  3. #3
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Percentile Question

    Wow it can be done. I learned something new today. Thanks alot!!

+ 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