LOG10E.CONST


Returns the value of the base-10 logarithm of Euler’s number.

Syntax:

LOG10E.CONST()


Example:

LOG10E.CONST()

returns 0.434294482


LOG10E.CONST() =

0.434294482

Application:

Converting Sound Intensity to Decibels


The decibel (dB) scale is a logarithmic scale used to measure sound intensity. The formula for sound level in decibels is:



where I is the sound intensity being measured, and I0​ is the reference intensity (the threshold of human hearing, approximately 10−12 W/m2).


Imagine you are a scientist modeling the exponential decay of a sound wave's intensity as it travels through a medium. The intensity of the sound wave can be described by the formula:



where d is the distance from the source, and k is the decay constant of the medium.


To see how the sound level in decibels changes with distance, you would need to substitute the intensity function into the decibel formula:



Using the properties of logarithms, you can simplify this expression.




This is where the LOG10E.CONST constant comes in. The value of log10​(e) is approximately 0.434294.


Let's say you have an initial sound intensity Iinitial​=10−6 W/m2 and a decay constant k=0.25 m−1. You want to calculate the sound level in decibels at various distances.


Using the simplified formula:






You can now use this simplified linear equation to quickly calculate the decibel level at different distances, as shown in the table below. The LOG10E.CONST value was crucial for converting the natural exponential decay into a linear relationship on the base-10 decibel scale.

Distance (d in meters)

Sound Level in Decibels (LdB)

A
B
C
1
0
60−1.085735(0)
60.00 dB
2
5
60−1.085735(5)
54.57 dB
3
10
60−1.085735(10)
49.14 dB
4
20
60−1.085735(20)
38.28 dB




This page is protected by Google reCAPTCHA. Privacy - Terms.
 
Built using Zapof