Japanese version. Functions. Multiple values or average of a range of cells. Function Importance Description AVERAGE High Get the average of the values. AVERAGEA Low Get the average including non-numeric values. AVERAGEIF Middle Average of cell values matching the search criteria. AVERAGEIFS High Average of cell values matching multiple criteria. TRIMMEAN Middle Average with extreme values (outliers/abnormal values) removed. HARMEAN Middle Get harmonic mean. GEOMEAN Middle Get geometric mean (synergistic mean). Median/Mode/Standard Deviation/Frequency of multiple values or cell range. Function Importance Description MEDIAN High Get median. MODE.SNGLMODE.MULT Middle Get mode (the number that appears most frequently). STDEV.P Middle Get standard deviation. FREQUENCY Low Get the number of numbers in the … Continue reading Statistical(Microsoft Excel Functions)