> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/acron-9.3/en/intro/funktionen/funk_statistik.md). # Functions Statistics This group contains functions that you use to evaluate data statistically. In the group you will find the following functions: The first column of the table contains the name of the function as you enter it in an expression. The second column contains the data types of the argument(s), and the third column contains the data type of the function's return value. | Function | arguments | Return value | | ---------------------- | ------------------------------------------------- | ------------ | | [Avg](#func_avg) | (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | NUMBER | | [Max](#func_max) | (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | NUMBER | | [Min](#func_min) | (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | NUMBER | | [Sigma](#func_sigma) | (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | NUMBER | | [Sigma1](#func_sigma1) | (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | NUMBER | | [Sum](#func_sum) | (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | NUMBER | ## Avg function | | | | ------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Syntax: | NUMBER Avg (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | | Parameters: | | | Return value: | The arithmetic mean of the arguments passed. | | Description: |

The function calculates the arithmetic mean value from the passed arguments.

Invalid values (NoValid) are not taken into account in the calculation. They have no effect on the result of the calculation.

The function can be called with 2 to a maximum of 10 arguments.

| | Example: |

Avg (2,3) = 2,5

Avg (1,5,2,4,3) = 3

| ## Max function | | | | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Syntax: | NUMBER Max (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | | Parameters: | | | Return value: | The highest value from the passed arguments. | | Description: |

The function calculates the highest value from the passed arguments.

Invalid values (NoValid) are not taken into account in the calculation. They have no effect on the result of the calculation.

The function can be called with 2 to a maximum of 10 arguments.

| | Example: |

Max (2,3) = 3

Max (1,5,2,4,3) = 5

| | See also: | [Min function](#func_min) | ## Min function | | | | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Syntax: | NUMBER Min (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | | Parameters: | | | Return value: | The lowest value from the passed arguments. | | Description: |

The function calculates the lowest value from the passed arguments.

Invalid values (NoValid) are not taken into account in the calculation. They have no effect on the result of the calculation.

The function can be called with 2 to a maximum of 10 arguments.

| | Example: |

Min (2,3) = 2

Min (1,5,2,4,3) = 1

| | See also: | [Max function](#func_max) | ## Sigma function | | | | ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Syntax: | NUMBER Sigma (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | | Parameters: | | | Return value: | The standard deviation of the passed arguments. | | Description: |

Calculates the standard deviation based on the population given as arguments. The standard deviation is a measure of the variance of values in relation to their mean value (average).

The calculation uses the formula:

../resources/images/grundgesamtheit.png

Invalid values (NoValid) are not taken into account in the calculation. They have no effect on the result of the calculation.

The function can be called with 2 to a maximum of 10 arguments.

| | Example: |

Sigma (2,3) = 2,5

Sigma (1,5,2,4,3) = 3

| ## Sigma1 function | | | | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Syntax: | NUMBER Sigma1 (NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | | Parameters: | | | Return value: | The standard deviation of the passed arguments. | | Description: |

Determines the standard deviation based on a sample. The standard deviation is a measure of the variance of values in relation to their mean value (average).

The calculation uses the formula:

Invalid values (NoValid) are not taken into account in the calculation. They have no effect on the result of the calculation.

The function can be called with 2 to a maximum of 10 arguments.

| | Example: |

Sigma1 (2,3) = 2,5

Sigma1 (1,5,2,4,3) = 3

| ## Sum function | | | | ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Syntax: | NUMBER Sum(NUMBER, NUMBER \[, NUMBER, NUMBER, NUMBER, ...]) | | Parameters: | | | Return value: | The sum of all values passed as arguments. | | Description: |

The function calculates the sum of the passed values.

Invalid values (NoValid) are not taken into account in the calculation. They have no effect on the result of the calculation.

The function can be called with 2 to a maximum of 10 arguments.

| | Example: |

Sum (2,3) = 5

Sum (1,5,2,4,3) = 15

| --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.videc.de/acron-9.3/en/intro/funktionen/funk_statistik.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.