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)
Hey there. My name is Zach Bobbitt. I have a Masters of Science degree in Applied Statistics and I’ve worked on machine learning algorithms for professional businesses in both healthcare and retail. I’m passionate about statistics, machine learning, and data visualization and I created Statology to be a resource for both students and teachers alike. My goal with this site is to help you learn statistics through using simple terms, plenty of real-world examples, and helpful illustrations.
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,