Trend line function.

[Fuga]

Hi all,

I would like to have a function in an access query showing the slope of a trendline (the linear one in excel).

Do you know how to create it?

Fuga.

 

[mjseim]

I'm trying to find the same thing. Have you figured this out?

 

[MailMan]

Trend Function

The following function works when called from VB:

Function TrendFunction(yRange(), xRange(), xNew, tLine As Boolean)

Dim TrendArray

TrendArray = Excel.WorksheetFunction.Trend(yRange, xRange, xNew, tLine)
TrendFunction = TrendArray(1)
​

End Function

 

[Fuga]

Thanks mailman!

I haven´t seen this until now. I will definitely try it.

Fuga.