For a > 0, the variables change to Y = ln ( y) and A = ln ( a),.After changing the variables, the calculations are similar to the linear case Y = b * x + A: Note: Excel uses a linear model to fit an exponential function: the exponential function y = a * e bx is transformed into a linear function using a change of variables. the result of EXP (1) - see below the description of this function). e is the mathematical constant, the base of the natural logarithm (also known as Euler's number, approximately equal to 2.71828.a and b are the parameters of the approximating function (also named function coefficients or constants),.The exponential trendline is a curved line described by the function: a dependent or response variable y (named as known_y's).Įxponential trendline equation and formulas.an independent, predictor, or explanatory variable x (named as known_x's),.When calculating a trend line, two sets of variables are required: Excel uses the least squares method to find the best fitting line for the data points.
