*54*

**Logarithmic regression** is a type of regression used to model situations where growth or decay accelerates rapidly at first and then slows over time.

For example, the following plot demonstrates an example of logarithmic decay:

For this type of situation, the relationship between a predictor variable and a response variable could be modeled well using logarithmic regression.

The equation of a logarithmic regression model takes the following form:

**y = a + b*ln(x)**

where:

**y:**The response variable**x:**The predictor variable**a, b:**The regression coefficients that describe the relationship betweenÂ*x*and*y*

The following step-by-step example shows how to perform logarithmic regression in Excel.

**Step 1: Create the Data**

First, letâ€™s create some fake data for two variables:Â *x* andÂ *y*:

**Step 2: Take the Natural Log of the Predictor Variable**

Next, we need to create a new column that represents the natural log of the predictor variable *x*:

**Step 3: Fit the Logarithmic Regression Model**

Next, weâ€™ll fit the logarithmic regression model. To do so, click the **Data** tab along the top ribbon, then click **Data Analysis** within theÂ **Analysis** group.

*If you donâ€™t see Data Analysis as an option, you need to first load the Analysis ToolPak.*

In the window that pops up, clickÂ **Regression**. In the new window that pops up, fill in the following information:

Once you clickÂ **OK**, the output of the logarithmic regression model will be shown:

The overall F-value of the model is 828.18 and the corresponding p-value is extremely small (3.70174E-13), which indicates that the model as a whole is useful.

Using the coefficients from the output table, we can see that the fitted logarithmic regression equation is:

**y = 63.0686 â€“ 20.1987 * ln(x)**

We can use this equation to predict the response variable,Â *y*, based on the value of the predictor variable,Â *x*. For example, ifÂ *x*Â = 12, then we would predict thatÂ *y*Â would beÂ **12.87**:

y = 63.0686 â€“ 20.1987 * ln(12) =Â **12.87**

**Bonus:** Feel free to use this online Logarithmic Regression Calculator to automatically compute the logarithmic regression equation for a given predictor and response variable.

**Additional Resources**

How to Perform Simple Linear Regression in Excel

How to Perform Multiple Linear Regression in Excel

How to Perform Polynomial Regression in Excel

How to Perform Exponential Regression in Excel