MicroStrategy ONE
ChiSquareTest (Chi-Square Test for Goodness of Fit)
Returns the result of a test for goodness of fit. 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: H0 is correct | Reality: H1 is correct |
Accept H0 |
No problem |
Type 1 error |
Reject H0 |
Type 2 error |
No problem |
Definition
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
)
Where:
Argument1
is a fact or metric representing a list of values that contains observed values, which are to be tested against expected values.
Argument2
is a fact or metric representing a list of expected values, which are compared against the observed values provided by Argument1
.
Usage Notes
This function returns the probability for a chi-squared (x
2) statistic and its associated degrees of freedom (df
).
This function results in an invalid value if Argument1
and Argument2
have a different number of data points. Meaning, each observed value must have an expected value to be compared to.