to get its k-value from percentile and array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi folks,
Is it a way to get its k-value from percentile and array. Thanks.
PeterK
 
Hi,

I'm struggling to make a connection between K value, percentile and array or
understand a specific question. Please expand.

Mike
 
Perhaps this is a question about the FREQUENCY function? Just a shot in the
dark though.
 
Hi Mike,
I am apology for unclear description of my problem. My boss just
answered my question. It is the function percenrank. I am using the following
to explian.
Function percentile(array, k-value) returns a percentile
percentrange(array, percentile) retruns a k-value
Hopefully, it is right.
PeterK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using percentile in an array formula 1
Percentile 1
Ignore Zero's - Percentile 2
PERCENTILE exceeding 8191 points 1
PERCENTILE with an IF Clause 2
Percentiles in Excel 2
Percentile function using a cell reference for the array 1
Sumproduct and Percentile 4

Back
Top