To use this function, choose Calc > Calculator.

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


Column statistic

For number, specify the column number.

Row statistic

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

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy