>I'll try the LINEST function as well as your macro.Yes. For example, coeffiecients for a logarithmic trendline come from:
>I thought that LINEST only performs a linear regression, so a regression
>that yields y=mx+n. Obviously it also works for polynomials.
>But does it also work for LN, e-power and x-power equations?
(You will likely need to use the EXP() function on the constant
Of course, that's just my opinion. I could be wrong.
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.