From the course: Excel Statistics Essential Training: 2 (2019)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Performing logarithmic regression analysis

Performing logarithmic regression analysis

From the course: Excel Statistics Essential Training: 2 (2019)

Start my 1-month free trial

Performing logarithmic regression analysis

- [Instructor] Now I'll tell you about a kind of non-linear regression called logarithmic regression. Use it as a model when a multiplicative change in x, results in an additive change in y. For example, if you start out with $100, and have compound interest on the x-axis, you multiply each x by 1.10 to produce the next one, and simple interest on the y-axis, add point 10 to each y to produce the next one, the relationship between x and y is a logarithmic one. The equation of logarithmic regression, as you can see here in the box, is y-hat equals a times the natural log of x plus b. As in any kind of regression analysis, part of the objective is to find the values of a and b that best fit the data. Here we have the data for female shot putters. Column A holds each athletes one rep max, and a core strengthening exercise called the Power Clean. Column C shows each athletes personal best shot putt in meters. The scatter plot and logarithmic regression curve, regression function and r…

Contents