Statistical Functions in Calc
Count: It is used to count the numeric value in the given cell range.
Syntax: =count(Value 1, Value 2,...) : Value 1, Value 2,... are the arguments containing different data types but where only number are counted.
Ex- = count(A1:A10)
--------------------------------------
Counta: It counts the number of cell in a range that is not empty.
Syntax: =count(Value 1, Value 2,...) : Value 1, Value 2,... are the arguments representing the value to be counted.
Ex- = counta(A1:A10)
--------------------------------------
Countif: It is used to count the number of cells within a range that meet the given condition.
Syntax: =countif(range, criteria) : The range of the cell to be evaluated by the criteria given
Ex- =countif(d5:d11,">20")
--------------------------------------
Min: Function is used to gives the minimum value in the given range of cell.
Syntax: =min(Number 1, Number 2,...) : Number 1, Number 2,...are the numerical arguments for which the smallest number is to be determined.
Ex- =Min (A1:D5)
--------------------------------------
Max: Function is used to gives the maximum value in the given range of cell.
Syntax: =max(Number 1, Number 2,...) : Number 1, Number 2,...are the numerical arguments for which the largest number is to be determined.
Ex- =Max (A1:A11)
--------------------------------------
Average: The Average function return the average of given arithmetic values within a range.
Syntax: =average(Number 1, Number 2,...) : Number 1, Number 2,...are the numeric arguments representing a population sample.
Ex:- =average(A1:A11)
--------------------------------------
Averageif: The Averageif function in Calc calculates the average of cells that meet one criteria.
Syntax: =Averageif(Range, Criteria) : The range to be evaluated by given criteria.
Ex:- =average(A1:A11,">10")
0 Comments