- Formula
- Δ ≤ 6: Lsb − 1.3 · 6 < Δ < 10: 10·log₁₀(10^(Lsb/10) − 10^(Lb/10)) · Δ ≥ 10: Lsb
- Output
- dB
- Bands
- Two levels
- Standard / Source
- ISO 16283-1
- Access
- Inline =function
What it does
Corrects a measured level for background noise using the three-band rule of ISO 16283-1 (Formula 14): the level of signal-plus-background Lsb is compared with the background level Lb, and
- if the difference is 6 dB or less, the background is too close to separate, so 1.3 dB is subtracted;
- if it is more than 6 but less than 10 dB, the background is removed on an energy basis (the same subtraction as
=DBSUB); - if it is 10 dB or more, no correction is made.
Equation
With Δ = Lsb − Lb:
The branch is chosen on the unrounded difference. In the middle branch both inputs are first rounded to one decimal place.
How to use it
=BGCORRECT(Lsb, Lb)
=BGCORRECT(60, 52)The older spelling =BGCORR still works.
Worked example
| Lsb (dB) | Lb (dB) | Δ (dB) | Result |
|---|---|---|---|
| 60 | 55 | 5 | 60 − 1.3 = 58.7 dB |
| 60 | 52 | 8 | 10·log₁₀(10⁶ − 10⁵·²) = 59.3 dB |
| 60 | 48 | 12 | 60.0 dB (no correction) |
Source
ISO 16283-1 — Formula 14, background noise correction.