Data requirements: Any array/range with real numbers. Note: the data

series has to contain between 1 and 8,191 data points

6.3.B PERCENTILE

This function returns the Pth percentile of values in a data series. You can

use this function to establish a threshold of acceptance. For example, you

can prefer to examine candidates who score above the 95th percentile will

qualify for a scholarship.

95

Statistical Analysis with Excel

Menu path to function:

INSERT/FUNCTION/STATISTICAL/PERCENTILE.

Figure 90: Estimating the 5th percentile. K is the percentile value in the range 0 to 1.

Data requirements: Any array/range with real numbers. If the data array

is empty or contains more than 8,191 data points, PERCENTILE returns

the” #NUM!” error value. If K is not a multiple of (1/(n ” 1)), then Excel

interpolates the value at the Kth percentile.

Figure 91: Estimating the 95th percentile

6.3.C MAXIMUM, MINIMUM AND “KTH LARGEST”

MAX (“Maximum value”)

MAX and MAXA: The functions calculate the largest value in a series.

96

Chapter 6: Functions for Basic Statistics

Menu path to function: STATISTICAL/MAX , & STATISTICAL/MAXA.

Data Requirements: Any array/range with real numbers. In addition,

MAXA may include “True,” “False,” or numbers in text format

MIN (“Minimum value”)

MIN and MINA: The functions calculate the smallest value in a series

Menu path to function: STATISTICAL/MIN, & STATISTICAL/MINA

Data Requirements: Any array/range with real numbers. In addition,

MINA include “True,” “False,” or numbers in text format

LARGE

This function calculates the Kth largest value in a range.

Figure 92: LARGE

Menu path to function: STATISTICAL/LARGE

Data Requirements: Any real number.

97

Statistical Analysis with Excel

SMALL

This function calculates the Kth smallest value in a range.

Menu path to function: STATISTICAL/SMALL

Data Requirements: Any real number.

6.3.D RANK OR RELATIVE STANDING OF EACH CELL WITHIN THE

RANGE OF A SERIES

PERCENTRANK

The PERCENTRANK function returns the rank of a value in a data set as

a percentage of the data set. The function can be used to evaluate the

relative standing of a value within a data set. For example, you can use

PERCENTRANK to evaluate the standing of a test score among all scores

for the test.

Figure 93: Percentrank of the average/mean

Menu path to function: INSERT/FUNCTION / STATISTICAL /

PERCENTRANK.

98

Chapter 6: Functions for Basic Statistics