Statistical functions of Excel in Amibroker

Dear Members,

I am attempting to work on time series forecast model in Amibroker which I have successfully calculated in MS Excel however I am unable to relate certain statistical function available in MS Excel with Amibroker existing function or how to code it afl.

Such as LINEST, INDEX, and F.DIST.RT, any reference to proceed will be highly helpful.

I am ready to brief if or share the excel template if required.

Regards

Deepak

AmiBroker already provides TSF() function.

Excel Functions AmiBroker Functions
LINEST

LinRegIntercept - Intercept of linear regression line
LinRegSlope - linear regression slope

INDEX

BarIndex() - Use ValueWhen() to call or use a loop as and when required. Anything is possible!
F.DIST.RT

StdErr - standard error
StDev - standard deviation

TSF() must fit any kind of Time Series Forecast model that you're trying to develop.

Besides that in regards to LINEST() you may also refer to Edward Pottasch's Least Squares Channel Indicator from member's library for a working example.

And for F.DIST.RT, refer to on how to calculate Chi-Square Distribution (φ it enters all analysis of variance problems via its role in the F-distribution). Then, F Distribution is nothing but ratio of two Chi-Square Distributions.

7 Likes

Thanks @Cougar it's really helpful..

1 Like