MicroStrategy ONE

MeanTTest (Mean T-test)

Calculates the P-value of a T-test that tests the mean of the data against a particular value. This function is used to determine the closeness in the value of the means of two samples coming from the same population.

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.

MeanTTest returns the p-value for the hypothesis test in the following form:

  • For H0:

  • For H1:

Syntax

MeanTTest <Hypothesis type> (Argument, Hypothesis mean)

Where:

Argument is the value or list of values, represented by a fact or metric, that contains sample data.

Hypothesis mean is m0.

Hypothesistype denotes the type of t-test to be performed. Hypothesis type can be -1, 0, 1, or 2.