Excel VBA or Application: Percentile estimates

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.
ys79Asked:
Who is Participating?
 
byundtCommented:
Hi ys79,
=PERCENTILE(A1:A500,0.25)    returns the 25%-tile
=PERCENTILE(A1:A500,0.75)    returns the 75%-tile


Cheers!

Brad
0
 
byundtCommented:
ys79,
Thanks for the grade!
Brad
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.