Logarithmic trendlines

  • Thread starter Thread starter Reece Bradley
  • Start date Start date
R

Reece Bradley

Can someone please tell me how to display a log base 10 equation for a
logarithmic trendline in an excel chart
 
Multiply the coefficient of ln(x) by ln(10).

Alternatively, get the coefficients in the worksheet by selecting a 5 row by
2 column range and entering the array formula
=LINEST(range-with-y-values,LOG10(range-with-x-values),TRUE,TRUE).

To enter an array formula complete data entry with the CTRL+SHIFT+ENTER
combination rather than just the ENTER or TAB key.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logarithmic Trendline 2
logarithmic trendline equation 1
Why is a logarithmic not always an option under trendline type? 2
Logarithmic Trendline - Please Help 1
Logarithmic Trendline - Please Help 2
Logarithmic trendline unavailable 2
Trendline error 2
copy trendline logarithmic constants to a cell 3

Back
Top