How to Log Transform Data in Excel - 4 Methods

The dataset below showcases the number of deaths up to June 1st, 2022 in 6 different countries.

What Is Log Transform?

Log Transform transforms a skewed data distribution to conform normality.

The Logarithm is: p = Log_q(r),

It also can be written as, q^p = r.

The base is q, which can be any positive number (except 1).

10 is the most common base, but the base selection depends on the statistical model of the research.

Steps:

=LOG10(D5)

Data is transformed from normal scale to Log scale.

Steps:

=LOG(D5)

This is the output.

Similar Readings

Steps:

=LOG(D5,5)

This is the output.

Steps:

In the Developer tab >>> select Visual Basic (You can also press ALT + F11).

Sub Log_Transform_Data()
Dim z As Integer
For z = 5 To 10
    Cells(z, 5) = Log(Cells(z, 4))
Next z
End Sub

VBA Code Breakdown

The Log_Transform_Data Sub Procedure is called.
The variable type is defined.
The For Next Loop goes through the data. 5 is provided as the starting value (data starts in row 5).
The Cells property is used to enter values.
The VBA Log function is used, and the Cells property goes through our cell values.

This is the output.

Do not provide numerical values in the LOG function (the “#Value!” error is displayed).
If the base is 0 or a negative number, the “#Num!” error is displayed.
If the base is 1, the “#DIV/0!” error is displayed.