Table Summary Statistics

MIMIC includes the following table summary statistics:

Table StatisticDescription

Sum

Indicates the sum total of the values returned in the answers.

Average

Indicates the average of the data for a column.

Average (+)

Indicates the average of all the values in the answers.
Average (-)Indicates the average of the negative answers to the query.

Percent (+)

Percent positive. Indicates the number, as a percentage of the total number of occurrences, of positive answers to the query

Percent (-)Percent negative. Indicates the number, as a percentage of the total number of occurrences, of negative answers to the query.
MaximumIndicates the maximum of all the query answers.
MinimumIndicates the minimum of all the query answers.
Std DeviationMeasures the mean deviation from the average of the answers. This can be a particularly valuable tool to interpret the answers to the query. For example, if the average return on a query is 3%, but the Standard Deviation on that is 10%, then it indicates a poor signal. It is best to have a standard deviation that is lower than the absolute value of the average value returned in the query.
ZstatIndicates the Z-score of the results. This measures the goodness of the average.
VarianceThis is related to the standard deviation calculation, which is actually the square root of the variance.
LastRepeats the last value of the column data.

MIMIC does not sort table summary statistics.