This calculator produces a logarithmic regression equation based on values for a predictor variable and a response variable.

Simply enter a list of values for a predictor variable and a response variable in the boxes below, then click the “Calculate” button:

**Predictor values:**

**Response values:**

**Logarithmic Regression Equation:**

ŷ = -5.1656 + 10.1997 * ln(x)

Zach,

I am a novice Excel user trying to generate a simple logarithmic equation.

I have found the intercept equation to determine intercept coeffecient as the regression Data Analysis tool returns. -5.1656 as shown in your example above.

I am looking to use a formula to calculate the other number “10.1997” as shown in your example but I can’t seem to find the right formula.

Please let me know the formula used to calculate this value if there is one.

Thanks,