Publication date: 11/29/2021

You can add columns of descriptive summary statistics for any numeric column in the source table by clicking the Statistics button and making a selection from the menu.

The Statistics menu gives these summary statistics for numeric columns:

N

The number of nonmissing values.

Mean

The arithmetic mean of a column’s values. It is the sum of nonmissing values (and if defined, multiplied by the weight variable) divided by the Sum Wgt.

Std Dev

The sample standard deviation, computed for the nonmissing values and calculated with the specified weight variable. It is the square root of the sample variance. The formula follows:

Min

The smallest nonmissing value in a column.

Max

The largest nonmissing value in a column.

Range

The difference between Max and Min.

% of Total

The percent of the total count for each group. Or, if you have so specified, the percent of nonmissing values of the column to the total count for each group.

N Missing

The number of missing values.

N Categories

The number of distinct categories.

Sum

The sum of all values in a column.

Sum Wgt

The sum of all weight values in a column. (See Column Properties in JMP.) Or, if no column is assigned the weight role, Sum Wgt is the total number of nonmissing values.

Variance

The sample variance, computed for the nonmissing values. It is the sum of squared deviations from the mean, divided by the number of nonmissing values minus one.

Std Err

The standard error of the mean. It is the standard deviation divided by the square root of N. If a column is assigned the role of weight, then the denominator is the square root of the sum of the weights.

CV (Coefficient of Variation)

The measure of dispersion, which is the standard deviation divided by the mean multiplied by one hundred.

Median

The 50th percentile, which is the value where half the data are below and half are above or equal to the 50th quantile (median).

Median Absolute Deviation

The median of the absolute deviation from the data’s median.

Geometric Mean

The nth root of the product of the data. For example, geometric means are often used to calculate interest rates. The statistic is also helpful when the data contains a large value in a skewed distribution.

Note: Negative values result in missing numbers, and zero values (with no negative values) result in zero.

Interquartile Range

The difference between the third and first quartiles.

Quantiles

the value at which the specific percentage of the argument is less than or equal to. For example, 75% of the data is less than the 75th quantile. The summary window has an edit box for entering the quantile percentage that you want.

Histogram

Generates histograms for different groups. Images of the histograms are saved in data table Expression columns.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).