Is there a list of statistical tests that QlikView performs?

[#1]

Hello,

I am interested in performing a Spearman's Correlation using QlikView.

Is there an extension for this?  Do I need R for this?

Would someone please provide me a list of all the tests that QlikView can perform?

Thank you.

Michael

[Gysbert_Wassenaar]

Theoretically any test that can be coded in vbscript or javascript can be performed. In practice you're probably better off doing any advanced statistical analysis in R.

Qlikview does have a correl function. Perhaps that suits your needs.

Look up the Statistical distribution functions and Statistical test functions in.... sections in the help file.

[ogautier62]

Hello,

either $ (id) identifying data

$ (f1) and $ (f2) the two data to compare

the respective ranks are given by:

aggr (num (rank (- $ (f1), 2)), $ (id)) ditto with $ (f2)

the correlation coefficient of spearman is then:

Correl (aggr (num (rank (- $ (f1), 2)), $ (id)), aggr (num (rank (- $ (f2), 2)), $ (id)))

Regards,

Note: Message edited by Community Moderator to include English translation as a courtesy. Please use English in main forums.

- - - - - -

Bonjour,

soit $(id) identifiant des données

$(f1) et $(f2) les deux données à comparer

les rangs respectifs sont donnés par :

aggr(num(rank( - $(f1),2)),$(id))   idem avec $(f2)

le coef de corrélation de spearman est alors :

Correl(aggr(num(rank( - $(f1),2)),$(id)),aggr(num(rank( - $(f2),2)),$(id)))

regards,