# Natural Log Regression Formula (manually)

• Jan 10th 2013, 07:55 AM
TheRhino1987
Natural Log Regression Formula (solved)
Hello,

I am trying to find out how to create a natural log regression formula from the following data...

X Y
1.11 6.71
0.97 5.79
0.82 4.55
0.72 3.30
0.70 2.51
0.65 2.18
0.60 1.80
0.76 3.89
0.67 3.01
0.62 2.64
0.60 1.90
0.55 1.58

I was able to determine the least squares regression model manually ( Y = 9.82x - 3.87 ).

I'm trying to program this function into Crystal Reports for a graph. The graph can generate the equation automatically, but it only prints the results out to the first decimal place. I need to do the calculations manually to get more accurate results. The automatically logarithmic equation generated is ( y = 7.8 * ln(x) + 5.9 )

Any help would be much appreciated...
• Jan 10th 2013, 10:48 AM
TheRhino1987
Re: Natural Log Regression Formula (manual calculation)
Wow... I figured it out. I just use the same method I used for finding the slope and Y int for the dataset, only, substitute the regular x values for ln(x) values, and you get the natural log regression slope and y int...
DURP!
/Face