- Formula
- Lavg = 10·log₁₀( Σ 10^(Li/10) / N )
- Output
- dB
- Bands
- Any set of levels
- Standard / Source
- General acoustics (no standard cited)
- Access
- Inline =function
What it does
Returns the energy average of a set of sound levels — the logarithmic mean, i.e. the level of a single steady source carrying the same total energy averaged over N samples. Use it to average repeated measurements or positions.
Equation
How to use it
=DBAVG(80, 82, 85)
=DBAVG(A1:A3)Worked example
=DBAVG(80, 82, 85) → 82.8 dB
(Higher than the arithmetic mean of 82.3, because energy averaging is weighted towards the louder values.)
Source
Standard energy averaging of levels. No specific published standard is cited in the software.