MicroStrategy ONE
Variance test
Returns the P-value of a test that tests the variance of the data against a particular value.
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 basically a probability of making a Type 2 error.
VarTest returns the P-value for the hypothesis test in the following form:
-
H0:
-
H1:
Syntax
VarTest <Hypothesis Type> (
Argument
,
Hypothesis Variance
)
Where:
Hypothesis Type
is the parameter to set whether you are testing the probability of the value being equal (0), less than (-1), greater than (1), or not equal to (2) the sigma or variance.
Argument
is a fact or metric representing the values you are testing.
Hypothesis
Variance
is the variance you are testing.
Example
VarTest(M1, 1000) = 1000
For a set of values (M1), what is the probability that the variance of the value will be equal to 1000? Note that M1 needs to have a defined dimensionality.
Usage Notes
For each variance test function, two tests are performed. The first tests the probability of the value being equal (0), and the second tests the probability of the value being less than (-1), greater than (1), or not equal to (2) the sigma or variance. A parameter must be specified for the second test.