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.

Examples

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

Uses

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