How to Perform Logarithmic Regression in Excel

In this tutorial, you will learn how to perform Logarithmic Regression in Excel.

The logistic model, often known as the logit model, is a statistical model that estimates the likelihood of an event occurring by making the event’s log odds a linear combination of one or more independent variables.

Once ready, we’ll get started by utilizing real-world examples to show you how to perform Logarithmic Regression in Excel.

LOGEST Function Formula

=LOGEST(x, y1, y2)

LOGEST determines the logarithm of a specified value.

Perform Logarithmic Regression in Excel

Before we begin we will need a group of data to perform Logarithmic Regression in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

To calculate the logarithmic regression we will use this formula =LOGEST(B2:B7, A2:A7).

Step 3

Once you press Enter, your formula will return the logarithmic regression.