Solved

Excel VBA or Application: Percentile estimates

Posted on 2003-12-10
2
629 Views
Last Modified: 2006-11-17
Can excel estimate percentile estimates? I want to be able to give Excel a range of number and have it caculate the 25%-tile and 75%-tile.
0
Comment
Question by:ys79
  • 2
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 125 total points
ID: 9912864
Hi ys79,
=PERCENTILE(A1:A500,0.25)    returns the 25%-tile
=PERCENTILE(A1:A500,0.75)    returns the 75%-tile


Cheers!

Brad
0
 
LVL 81

Expert Comment

by:byundt
ID: 9914144
ys79,
Thanks for the grade!
Brad
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question