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.