Statistical(Microsoft Excel Functions)

05/15/2024

Japanese version.

Functions.

Multiple values or average of a range of cells.

FunctionImportanceDescription
AVERAGEHighGet the average of the values.
AVERAGEALowGet the average including non-numeric values.
AVERAGEIFMiddleAverage of cell values matching the search criteria.
AVERAGEIFSHighAverage of cell values matching multiple criteria.
TRIMMEANMiddleAverage with extreme values (outliers/abnormal values) removed.
HARMEANMiddleGet harmonic mean.
GEOMEANMiddleGet geometric mean (synergistic mean).

Count of multiple values or cell ranges.

FunctionImportanceDescription
COUNTHighCount of multiple values or cell ranges.
COUNTAHighGet the number of non-blanks.
COUNTBLANKMiddleGet the number of blanks.
COUNTIFMiddleGet the number of cells matching the search criteria.
COUNTIFSHighGet the number of rows that match multiple criteria.

Maximum/minimum values for multiple values or cell ranges.

FunctionImportanceDescription
MINHighGet the smallest number.
MAXHighGet the largest number.
MINAMiddleGet the minimum value, including spaces and boolean values.
MAXAMiddleGet the maximum value, including spaces and boolean values.
MINIFSHighGet the minimum value in a cell that matches multiple criteria.
MAXIFSHighGet the maximum value in a cell that matches multiple criteria.

Median/Mode/Standard Deviation/Frequency of multiple values or cell range.

FunctionImportanceDescription
MEDIANHighGet median.
MODE.SNGL
MODE.MULT
MiddleGet mode (the number that appears most frequently).
STDEV.PMiddleGet standard deviation.
FREQUENCYLowGet the number of numbers in the interval and create a frequency distribution table.

Ranking of multiple values or cell ranges.

FunctionImportanceDescription
RANK.EQ
RANK.AVG
HighGet the rank in the range.
LARGE
SMALL
MiddleGet the number corresponding to the rank.