Microsoft Office Tutorials and References

In Depth Information

**PERCENTILE**

A set of independent values; can be cell references, range names, or arrays.

ARRAY1

A set of dependent values; can be cell references, range names, or arrays.

ARRAY2

The equation for
PEARSON
is

Figure 11.33

When using the

PEARSON
function,

the arrays must have

the same number of

data points.

PERCENTILE

PERCENTILE
returns the
k-th percentile of values in a range.

=PERCENTILE(array,k)

The
PERCENTILE
function is used to a threshold of acceptance. In Figure 11.34, for example,

the price earning ratios of 12 companies is given. To find the value of the seventieth

percentile (the k value), the result is 28.3.

Is the data set that defines relative standing.

ARRAY

Is the percentile value between 0 and 1.

K