Solved

Excel VBA or Application: Percentile estimates

Posted on 2003-12-10
2
632 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

617 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