For exponential formula. Using your example...
=1.7242*EXP(-0.119*X)
Replace X with cell reference to where x value is stored.
For how to use LINEST to fit non-linear curve... see link.
https://newtonexcelbach.wordpress.co...curve-fitting/
For exponential formula. Using your example...
=1.7242*EXP(-0.119*X)
Replace X with cell reference to where x value is stored.
For how to use LINEST to fit non-linear curve... see link.
https://newtonexcelbach.wordpress.co...curve-fitting/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks