2

I was wondering, whether it's possible to get coefficients of logarithmic trendline from an excel chart ? I know you can display them, but I'd like to have them in two different cells. Thanks in advance for help !

best regards, Bartek

haver24
  • 241
  • 2
  • 5
  • 11
  • Read the display and type them in.... – duffymo Jun 07 '12 at 11:12
  • possible duplicate of [Quadratic and cubic regression in Excel](http://stackoverflow.com/questions/10857252/quadratic-and-cubic-regression-in-excel). This is a slight variant on how to use `LINEST` beyond linear regression – brettdj Jun 08 '12 at 04:58

1 Answers1

1

First result for Google search "logarithmic trendline formula excel" works for me:

http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/

Note that you can right-click the trendline equation and choose Format Trendline Label... with Scientific Format and 14 decimal places to see full precision.

lori_m
  • 5,487
  • 1
  • 18
  • 29