Profiler Object:Column-Based Numeric Statistics

← Profiler Object Reference

These statistics should only be retrieved after calling the ProfileData function. These values are all column-specific. Numeric statistics are computed for all column types including non numeric-based ones (such as strings, date/times, etc.)

Quartiles and Medians

A median value is the 'middle' value. That is, if one were to order a list of 100 values from lowest to highest (including duplicate values), the median value is the value of the 50th item. There are two quartile values: first and third. In our example, the first quartile would be the 25th value, and the third quartile would be the 75th value. In cases where the total number of records is not evenly divisible, then a pair of quartile values is computed: the integral quartile, which is the value closest to the quartile or median point, and the interpolated quartile, which is an interpolated quartile value.

GetColumnNumericMaxValue

This function returns the column’s largest value as sorted numerically.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns largest value.

Syntax	profiler->GetColumnNumericMaxValue(columnNameStr);
C	double = mdProfilerGetColumnNumericMaxValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericMaxValue(columnNameStr);

GetColumnNumericMinValue

This function returns the column’s smallest numeric value.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns smallest value.

Syntax	profiler->GetColumnNumericMinValue(columnNameStr);
C	double = mdProfilerGetColumnNumericMinValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericMinValue(columnNameStr);

GetColumnNumericAvgValue

This function returns the column’s numeric average value.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns average value.

Syntax	profiler->GetColumnNumericAvgValue(columnNameStr);
C	double = mdProfilerGetColumnNumericAvgValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericAvgValue(columnNameStr);

GetColumnNumericQ1Value

This function returns the column’s first interpolated quartile value.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns first interpolated quartile value.

Syntax	profiler->GetColumnNumericQ1Value(columnNameStr);
C	double = mdProfilerGetColumnNumericQ1Value(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericQ1Value(ColumnNameStr);

GetColumnNumericQ1IntValue

This function returns the column’s first integral quartile value. This is a value from your input data that is closest to the quartile value (non-interpolated).

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns first integral quartile value.

Syntax	profiler->GetColumnNumericQ1IntValue(columnNameStr);
C	double = mdProfilerGetColumnNumericQ1IntValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericQ1IntValue(columnNameStr);

GetColumnNumericMedValue

This function returns the column’s interpolated median value.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns interpolated median value.

Syntax	profiler->GetColumnNumericMedValue(columnNameStr);
C	double = mdProfilerGetColumnNumericMedValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericMedValue(columnNameStr);

GetColumnNumericMedIntValue

This function returns the column’s Integral median quartile value. This is a value from your input data that is closest to the quartile value (non-interpolated).

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns integral median quartile value.

Syntax	profiler->GetColumnNumericMedIntValue(columnNameStr);
C	double = mdProfilerGetColumnNumericMedIntValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericMedIntValue(columnNameStr);

GetColumnNumericQ3Value

This function returns the column’s third interpolated quartile value.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns third interpolated quartile value.

Syntax	profiler->GetColumnNumericQ3Value(columnNameStr);
C	double = mdProfilerGetColumnNumericQ3Value(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericQ3Value(columnNameStr);

GetColumnNumericQ3IntValue

This function returns the column’s third integral quartile value. This is a value from your input data that is closest to the quartile value (non-interpolated).

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns third integral quartile value.

Syntax	profiler->GetColumnNumericQ3IntValue(columnNameStr);
C	double = mdProfilerGetColumnNumericQ3IntValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericQ3IntValue(columnNameStr);

GetColumnNumericStdDevValue

This function returns the column’s population standard deviation value.

This function takes one parameter.

Parameters

Name	Data Type	Description
ColumnName	String	Column Name to get the columns population standard deviation value.

Syntax	profiler->GetColumnNumericStdDevValue(columnNameStr);
C	double = mdProfilerGetColumnNumericStdDevValue(profiler, columnNameStr);
.Net	double = profiler.GetColumNumericStdDevValue(columnNameStr);