0
$\begingroup$

Suppose that I have two columns of data, C1:C5 as inputs and D1:D5 as responses, and I set a logarithmic trendline on the resulting scatterplot. The trendline equation will be of the form $y = a \ln(x) + b$, where $a$ and $b$ are constants. I know the formula to extract $b$: INTERCEPT(C1:C5, D1:D5). What's the equivalent formula for $a$?

$\endgroup$
6
  • $\begingroup$ See the help for SLOPE. $\endgroup$
    – whuber
    Nov 21 at 19:05
  • $\begingroup$ The only inputs for SLOPE are Known_ys and Known_xs. $\endgroup$
    – Forklift17
    Nov 21 at 19:13
  • $\begingroup$ That's right. The logs of the $x_i$ are the "known xs" and the $y_i$ are the "known ys." Excel computes logarithms with the LN function. $\endgroup$
    – whuber
    Nov 21 at 19:17
  • $\begingroup$ I'm aware of that. I still have no clue how to get that coefficient. I just need a formula to extract it. $\endgroup$
    – Forklift17
    Nov 21 at 19:23
  • 1
    $\begingroup$ This isn't the place for such questions. A site devoted to Excel questions would be a good place to ask it. $\endgroup$
    – whuber
    Nov 21 at 19:24

0

Browse other questions tagged or ask your own question.