Share via

LINEST function for exponential fit?

Anonymous
2010-04-04T02:24:09+00:00

What is the function that gives me an array similar to

LINEST

or

LOGEST

for an exponential fit?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-04-04T09:41:30+00:00

What I usually do is add a column with the formula =LN(y-Value cell) and use LINEST on that.

Ed Ferrero www.edferrero.com

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-04-04T19:19:54+00:00

    Yes, I feared that'd be the only way.

    Thx.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-04-04T08:15:23+00:00

    For example:

    I have a function that, in a graph, is fitted exponentially with y=A*exp(Bx)

    (How) can the values of the preexponential factor A and the B be displayed without manually writing them out into a spreadsheet?

    Is there a function to do this?

    thx.

    Was this answer helpful?

    0 comments