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.
Table of Contents
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.
First, you need to have a clean and tidy group of data to work with.
To calculate the logarithmic regression we will use this formula =LOGEST(B2:B7, A2:A7).
Once you press Enter, your formula will return the logarithmic regression.