Exponential / Power regression HELP!!!! 1

[ganpas]

Expo Equation: y = c *e ^(b * x)

Does any one know how to calculate c and b for a given set of X and Y values?? When I do trend line in excel, it automatically calculates the value for me. However, if I want to code in ASP/VB I need to know how excel arrive with the values for c and b when X and Y are given.

Power Equation: y=c*x^b

TIA

 

[m777182]

Transform the equations by taking LN or LOG of the variables:

LN=LN(c)+ b*x
and
LN=ln(c)+ b*LN(x)

m777182