Logarithmic regression in Excel

Reply Tue 4 Nov, 2014 07:14 pm
With reference to this regression line:
As shown in the bottom-right of this chart, the formula for the black regression line is:
y = 0.075ln(x) + 0.2775
How can I write this formula in Microsoft Excel, so that I can calculate y for any given value of x ? (I tried calculating it using Excel help, but it did not give me the correct y values shown in the regression line chart linked above).
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 1,203 • Replies: 0
No top replies


Related Topics

  1. Forums
  2. » Logarithmic regression in Excel
Copyright © 2020 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 08/12/2020 at 03:55:39