Range function

To use this function, choose Calc > Calculator.

Calculates the difference between the maximum value and the minimum value.

Syntax

Column statistic
RANGE(number)

For number, specify the column number.

Row statistic
RRANGE(number,number,...)

For number, specify each column number to define the length of the rows.

Column	Calculator expression	Result
C1 contains 6, 3, 15	RANGE(C1)	12
C1 contains 6, C2 contains 3, and C3 contains 15	RRANGE(C1,C2,C3)	12

In control charts and capability analyses, you can use the average range across all subgroups (Rbar) to estimate your process standard deviation