PDF chapter test TRY NOW
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)
Register for free to see more content