VBA Arrays and Exponential fit calculation - Excel 2010

cwunderlich

Board Regular
Joined
Sep 24, 2010
Messages
101
I have a macro which stores 10 values into an array (these are years, aka "known x's"). It also stores 10 values into a different array (these are data points, aka "known y's"). I plot these points to a scatter plot in excel and add an exponential trendline with the trendline formula displayed. The trend line formula gives me something along the lines of: 8E+79 e^(-.093x). What I want as a variable in my macro is this trend number of -.093. I have played around with growth(), linest(), logest() in excel to try to reproduce this -.093 number from the two data arrays as input, but no luck. Can someone please help me here?

Thanks,
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

cwunderlich

Board Regular
Joined
Sep 24, 2010
Messages
101
Nevermind, I think I solved it.

LINEST(LN(known y's),known x's) seems to do the trick
 

Watch MrExcel Video

Forum statistics

Threads
1,119,297
Messages
5,577,245
Members
412,777
Latest member
MrGray
Top