I've constructed an exponential curve, is there a function whereby I can
enter new y values to obtain the corresponding x values, instead of having to
print it off and read off manually?
Many thanks from a novice
-Helen Moore
I've constructed an exponential curve, is there a function whereby I can
enter new y values to obtain the corresponding x values, instead of having to
print it off and read off manually?
Many thanks from a novice
-Helen Moore
if Y=A*Exp(BX); then Ln(Y) - Ln(A) = BX or X= (Ln(Y) -Ln(A))/B
Also remember you can use LOGEST or LINEST to extract the trendline
coefficients into cells rather than copying them form equation on chart; see
http://www.stfx.ca/people/bliengme/E...&%20LOGEST.htm
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Helen" <Helen@discussions.microsoft.com> wrote in message
news:6779EAB3-CACA-4377-B2D4-75F4C5B2421E@microsoft.com...
> I've constructed an exponential curve, is there a function whereby I can
> enter new y values to obtain the corresponding x values, instead of having
> to
> print it off and read off manually?
>
> Many thanks from a novice
>
> -Helen Moore
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks