Forum Discussion
Maki-12345
Jan 25, 2020Copper Contributor
About EXCEL exponential approximation
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
Sort By
- JKPieterseSilver ContributorIt is using the so-called least squares method: https://en.wikipedia.org/wiki/Least_squares