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

"Peter" wrote:

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

Perhaps this is a question about the FREQUENCY function? Just a shot in the
dark though.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mike" wrote:

Hi,

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

Mike

"Peter" wrote:

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

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




"Mike" wrote:

Hi,

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

Mike

"Peter" wrote:

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