Results 1 to 2 of 2

Math Help - Natural Log Regression Formula (manually)

  1. #1
    Newbie
    Joined
    Jan 2013
    From
    United States
    Posts
    3

    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...
    Last edited by TheRhino1987; January 10th 2013 at 10:49 AM. Reason: SOLVED
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Jan 2013
    From
    United States
    Posts
    3

    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
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Natural Logarithm Regression Equation
    Posted in the New Users Forum
    Replies: 0
    Last Post: September 6th 2012, 08:18 PM
  2. Natural Logarithm Regression?
    Posted in the Calculus Forum
    Replies: 1
    Last Post: July 29th 2012, 08:54 PM
  3. [SOLVED] Formula For Logarithmic Regression
    Posted in the Advanced Statistics Forum
    Replies: 4
    Last Post: May 27th 2011, 04:20 PM
  4. simplifying to bivariate regression formula
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: January 18th 2010, 05:29 PM
  5. Natural Logarithm Regression Equation
    Posted in the Calculus Forum
    Replies: 1
    Last Post: August 10th 2009, 09:03 AM

Search Tags


/mathhelpforum @mathhelpforum