Skip to content
ContentsFormula ReferenceUser guide
Formula Reference

=DBAVG — Decibel Average

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

Lavg=10 log⁡10 ⁣(1N∑i10Li/10)L_{avg} = 10\,\log_{10}\!\left(\frac{1}{N}\sum_i 10^{L_i/10}\right)

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.

Register interest

Tell us a little about you and we'll be in touch when Timbral is ready.