Natural Log Regression Formula (solved)
I am trying to find out how to create a natural log regression formula from the following data...
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...