I am trying to create a function that will run an exponential regression for a range of data, my code thus far is as follows to figure out the A factor:
The formula I am using worked for me as an excel formula.
Function Avalue(xRange As Variant, yRange As Variant) As Variant
Avalue = System.Math.Exp(Application.WorksheetFunction.Index(Application.WorksheetFunction.LinEst((System.Math.Log(yRange) / System.Math.Log10(System.Math.Exp(1))), xRange), 1, 2))
End Function
Any suggestions would appreciated!
Bookmarks