Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel VBA or Application: Percentile estimates

Posted on 2003-12-10
2
Medium Priority
?
639 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 500 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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

824 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