MicroStrategy ONE
Chi-square test for independence
Returns the result of a test for independence. This function returns the chi-squared distribution for a statistical value and its associated degrees of freedom to determine, for example, to what extent an experiment verifies hypothesized results.
Decision | Reality:H0is correct |
Reality:H1is not correct |
---|---|---|
Accept H0 |
No problem |
Type 1 error |
Reject H0 |
Type 2 error |
No problem |
Definition
P-value = Pr[Reject H0| H0 is correct]
P-value is a probability of making a Type 2 error.
ChiSquareTest returns the P-value for the hypothesis test in the following form:
-
H0: Argument1 and argument2 come from the same distribution.
-
H1: Argument1 and argument2 come from different distributions.
Syntax
ChiSquareTest(Argument1, Argument2)
-
Argument1 is a fact or metric representing a list of values that contains observations to be tested against expected values.
-
Argument2 is a fact or metric representing a list of values that contains the ratio of the product of row totals and column totals to the grand total.
For additional information on this function, refer to the MicroStrategy Functions Reference.