Profiling Metrics

The profiling metrics produce statistical metrics such as percentile, geometric mean, or skew on a given dataset.

• Geometric Mean Metric (GMEAN): Calculates geometric mean, defined as the nth root of the product of n positive numbers.
• Percentile Metric (PERCENTILE): Calculates 1 to 100 percentile of numeric values.
• Skew Metric (SKEWCOEFF): Calculates Pearson’s coefficient of skewness on numeric values.

The URI for the data science functions is <http://cambridgesemantics.com/anzograph/statistics#>. For readability, the syntax for each function below includes the prefix stats:, defined as PREFIX stats: <http://cambridgesemantics.com/anzograph/statistics#>.

Geometric Mean Metric (GMEAN)

The Geometric mean function calculates geometric mean, defined as the nth root of the product of n positive numbers.

Syntax

stats:gmean(data)

Parameter	Type	Description
data	double	Column data.

Returns

Type	Description
double	The geometric mean value.

Percentile Metric (PERCENTILE)

The Percentile metric function calculates the percentile (1 to 100) of numeric values.

Syntax

stats:percentile(data, p)

Parameter	Type	Description
data	double	The dataset.
p	double	The percentile (0 - 100) to compute.

Returns

Type	Description
double	The percentile value.

Skew Metric (SKEWCOEFF)

The Skewness metric function calculates the Pearson’s coefficient of skewness on numeric values.

Syntax

stats:skewcoeff(data, dp)

Parameter	Type	Description
data	double	The dataset.
dp	int	Number of decimal points to consider for the input data.

Returns

Type	Description
double	The mode (value that appears most frequently).
double	The median number in an ordered set of data.
double	The average value.
double	The standard deviation.
double	Pearson mode skewness or first skewness coefficient.
double	Pearson median skewness or second skewness coefficient.