# Aggregate expressions¤

An aggregate expression is a type of function that performs calculations on a set of values and returns a single value as a result. These expressions are commonly used to summarize or condense data.

`!AVG`

: Average¤

Calculate the average / arithmetic mean.

Type: *Sequence*

Info

Read more about Arithmetic mean on Wikipedia.

Example

```
!AVG
- 6
- 2
- 4
```

Calculation of the average `(6+2+4)/3`

, the result is `4`

.

`!MAX`

: Maximum¤

Returns a maximum value from the seqence.

Type: *Sequence*

Example

```
!MAX
- 1.5
- 2.6
- 5.1
- 3.05
- 4.45
```

The result of this expression is `5.1`

.

`!MIN`

: Minimum¤

Returns a minimum value from the sequence.

Type: *Sequence*

Example

```
!MIN
- 2.6
- 3.05
- 4.45
- 0.5
- 5.1
```

The result of this expression is `0.5`

.

`!COUNT`

: Count number of items¤

Counts the number of items in a list.

Type: *Sequence*

Example

```
!COUNT
- Frodo Baggins
- Sam Gamgee
- Gandalf
- Legolas
- Gimli
- Aragorn
- Boromir of Gondor
- Merry Brandybuck
- Pippin Took
```

Returns `9`

.

`!MEDIAN`

: The middle value¤

The median is the middle value in a list of numbers; half of the values are greater than the median, and half are less than the median. If the list has an even number of elements, the median is the average of the two middle values.

Type: *Sequence*

Info

Read more about median on Wikipedia.

Example

```
!MEDIAN
- 1
- 4
- -1
- 9
- 101
```

Returns `4`

.

`!MODE`

: Value that appears most often¤

The mode is the value or values that occur most frequently in a list. It can be used to represent the central tendency of a data set.

Type: *Sequence*

Info

Read more about mode on Wikipedia.

Example

```
!MODE
- 10
- 10
- -20
- -20
- 6
- 10
```

Returns `10`

.

`!RANGE`

: The difference between the largest and smallest value¤

Calculates the difference between the largest and smallest values.

Type: *Sequence*

Info

Read more about range on Wikipedia.

Example

```
!RANGE
- 1
- 3
- 4
- 20
- -1
```