Using excel you could perform the regression above following the methodology (diffenrentiating and solving equations) but it defeats the purpose.Īlso, if you want the asymptotic part to fit better, you can skip the first x values (start at x=8 for instance) and use the built in exponential regression in xl. The trendline generated automatically by Excel only draws the line and prints the calculated coefficients. There is no built-in exponential regression tool to fit your data. 1 Answer Sorted by: 2 Looking at your picture, it seems that you have very few points and finding the largest of them is not enough. Which you are free to simplify/approximate. See below it is more visible when you apply ln() to the values and use a linear regression :Īdding an offset Y=ab^x-c won't cut it (or at least I couldn't do it)
The asymptotic part of the curve is biased by the lower x values which aren't consistent with the formula Y=a*exp(bx).
0 kommentar(er)
