Hello
I’ve got a query over how to generate a formula for an exponential trend line in Excel 2007 without creating a graph.
I’ve currently been using the following formulas:

Equation: y = c *e ^(b * x)
c: =EXP(INDEX(LINEST(LN(y),x),1,2))
b: =INDEX(LINEST(LN(y),x),1)

However, I want to repeat the process but set the intercept to zero. I need to run it 100,000 times so don't really want to create the graphs.

Does anyone know what the relevant formulas are?

Cheers Andy