- Formula
- RMS = √( Σ xᵢ² / N )
- Output
- same unit as the input values
- Bands
- Any set of values
- Standard / Source
- General acoustics (no standard cited)
- Access
- Inline =function
What it does
Returns the root mean square of a set of values — the same result as Excel's =SQRT(SUMSQ(range)/COUNT(range)), which it is defined to match. It is meant for linear quantities sampled down a column, such as repeated vibration velocity or acceleration readings (mm/s, m/s²) or sound pressures in Pa.
ℹ️ Do not use it on decibel values: dB are already logarithmic, so squaring and averaging them has no physical meaning. Use
=DBAVGfor an energy average of levels.
Equation
Blank cells and text are skipped, not counted as zero. Signs do not matter (−3 and 3 contribute equally). An empty range returns #DIV/0!.
How to use it
=RMS(C5:C40)
=RMS(3, 4)Worked example
=RMS(3, 4) → √((9 + 16) / 2) = 3.536
Source
Standard root-mean-square definition. No specific published standard is cited in the software.