Hello,

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

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