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...

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