Constants |
NONE |
returns the average of a field.
|
AVERAGE |
returns the average of a field.
|
CORRELATION |
returns the correlation of two fields.
|
COUNT |
counts the number of values, from the field.
|
COVARIANCE |
returns the measure of the linear relation between paired variables.
|
DISTINCTCOUNT |
returns the number of none repeating values, from the field.
|
MAXIMUM |
returns the largest value from the field.
|
MEDIAN |
returns the middle value in a sequence of numeric values.
|
MINIMUM |
returns the smallest value from the field.
|
MODE |
returns the most frequently returning value from the field.
|
NTHLARGEST |
returns the Nth largest value from the field.
|
NTHMOSTFREQUENT |
returns the Nth most commonly occurring value from the field.
|
NTHSMALLEST |
returns the Nth smallest value from the field.
|
PERCENTAGE |
returns as a percentage of the grand total summary.
|
PERCENTILE |
returns the value for a specified percentile in a Number or Currency field.
|
POPSTANDARDDEVIATION |
returns how much each value in the field deviate from the mean or average value for that field.
|
POPVARIANCE |
returns the square of the standard deviation.
|
SAMPLESTANDARDDEVIATION |
returns the sample standard deviation for the field.
|
SAMPLEVARIANCE |
returns the sample variance for the field.
|
SUM |
returns the total of all the values for the field.
|
WEIGHTEDAVG |
returns the weighted average for the field.
|
Constants' Details |
NONE
const short NONE = 0;
- Description
- returns the average of a field.
|
|
AVERAGE
const short AVERAGE = 1;
- Description
- returns the average of a field.
|
|
CORRELATION
const short CORRELATION = 2;
- Description
- returns the correlation of two fields.
|
|
COUNT
const short COUNT = 3;
- Description
- counts the number of values, from the field.
|
|
COVARIANCE
const short COVARIANCE = 4;
- Description
- returns the measure of the linear relation between paired variables.
|
|
DISTINCTCOUNT
const short DISTINCTCOUNT = 5;
- Description
- returns the number of none repeating values, from the field.
|
|
MAXIMUM
const short MAXIMUM = 6;
- Description
- returns the largest value from the field.
|
|
MEDIAN
const short MEDIAN = 7;
- Description
- returns the middle value in a sequence of numeric values.
|
|
MINIMUM
const short MINIMUM = 8;
- Description
- returns the smallest value from the field.
|
|
MODE
const short MODE = 9;
- Description
- returns the most frequently returning value from the field.
|
|
NTHLARGEST
const short NTHLARGEST = 10;
- Description
- returns the Nth largest value from the field.
|
|
NTHMOSTFREQUENT
const short NTHMOSTFREQUENT = 11;
- Description
- returns the Nth most commonly occurring value from the field.
|
|
NTHSMALLEST
const short NTHSMALLEST = 12;
- Description
- returns the Nth smallest value from the field.
|
|
PERCENTAGE
const short PERCENTAGE = 13;
- Description
- returns as a percentage of the grand total summary.
|
|
PERCENTILE
const short PERCENTILE = 14;
- Description
- returns the value for a specified percentile in a Number or Currency field.
|
|
POPSTANDARDDEVIATION
const short POPSTANDARDDEVIATION = 15;
- Description
- returns how much each value in the field deviate from the mean or average value for that field.
|
|
POPVARIANCE
const short POPVARIANCE = 16;
- Description
- returns the square of the standard deviation.
|
|
SAMPLESTANDARDDEVIATION
const short SAMPLESTANDARDDEVIATION = 17;
- Description
- returns the sample standard deviation for the field.
|
|
SAMPLEVARIANCE
const short SAMPLEVARIANCE = 18;
- Description
- returns the sample variance for the field.
|
|
SUM
const short SUM = 19;
- Description
- returns the total of all the values for the field.
|
|
WEIGHTEDAVG
const short WEIGHTEDAVG = 20;
- Description
- returns the weighted average for the field.
|
|
Copyright © 2000, 2014 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.