The COUNTBLANK function
The COUNTBLANK function provides us with a way to count the number of cells within a given cell range that are blank.
0305, 2019
Tag Archives: Statistical
0305, 2019
The COUNTIF Function
It returns the number of cells of a given cell range that meet a specific criterion.
0305, 2019
The AVERAGEIF Function
It returns the arithmetic mean (average) of all the cells in a given range that meet a specific criterion.
1904, 2019
The PERCENTILE.EXC function
It returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
1904, 2019
The PERCENTILE.INC function
It returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
1904, 2019
The PERCENTILE function
It returns the k-th percentile of values in a range. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are PERCENTILE.INC and PERCENTILE.EXC.
1904, 2019
The QUARTILE.EXC function
It returns the quartile of a data set based on percentile values from 0..1, exclusive.
1904, 2019
The QUARTILE.INC function
It returns the quartile of a data set based on percentile values from 0..1, inclusive.
1904, 2019
The QUARTILE function
It returns the quartile of a data set. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are QUARTILE.INC and QUARTILE.EXC.
1804, 2019
The COUNTIFS Function
The COUNTIFS function counts the number of times certain criterias are met. Even though its logical elements, it is part of the Statistical functions of Excel.
