Get A+ with YaClass!

Register now to understand any school subject with ease and get great results on your exams!

### Theory:

**Statistical Functions**:

LibreOffice Calc includes over \(70\) statistical functions which enable the evaluation of data from simple arithmetic calculations, such as averaging, to advanced distribution and probability computations.

Some of them are:

AVERAGE Function:

It calculates the average of the given set of values.

It calculates the average of the given set of values.

**Syntax**:

\(=AVERAGE(XY:XZ)\)

**Example**:

To calculate the average of the four fields\( C2 to C5\), you use the function,

\(=AVERAGE(C2:C5)\)

MAX Function:

It calculates the maximum value from a given set of values.

**Syntax**:

\(=MAX(XY:XZ)\)

**Example**:

To determine the maximum value of the four fields \(C2 to C5\), you use the function,

\(=MAX(C2:C5)\)

MIN Function:

It calculates the minimum value from a given set of values.

**Syntax**:

\(=MIN(XY:XZ)\)

**Example**:

To determine the minimum value of the four fields \(C2 to C5\), you use the function,

\(=MIN(C2:C5)\)

COUNT Function:

It counts the number of values (cell containing numbers).

**Syntax**:

\(=COUNT(XY:XZ)\)

**Example**:

To determine the number of values from the fields \(C2 to C5\), you use the function,

\(=COUNT(C2:C5)\)