About EXCEL exponential approximation

Copper Contributor

EXCEL has already shown that the equation of Y=a*e^bx is used to calculate exponential approximation within its software. I know that if there is only two variables like x and y, it is possible to solve fora and b. However, what kind of equation is the software using to solve for more than 3 types of x and y?

(Basically, I want to know the mechanism of approximation in EXCEL)

Sorry for my bad English. I'm in a rush so hope somebody can help me...!!!

1 Reply
It is using the so-called least squares method: https://en.wikipedia.org/wiki/Least_squares