GEOMEAN function. Get geometric mean (synergistic mean).(Microsoft Excel)
Japanese version.
Get geometric mean (synergistic mean).
How it works=GEOMEAN(number1 to 255)NameOmissionSpe ...HARMEAN function. Get harmonic mean.(Microsoft Excel)
Japanese version.
Get harmonic mean.
How it works=HARMEAN(number1 to 255)NameOmissionSpecifynumber1 to 255Re ...MEDIAN function. Get median.(Microsoft Excel)
Japanese version.
The median is the value of the middle rank when the data are arranged.
If the number of ...
TRIMMEAN function. Average with extreme values (outliers/abnormal values) removed.(Microsoft Excel)
Japanese version.
The TRIMMEAN function is a function that removes outliers and outliers, which are the weak po ...
AVERAGEIFS function. Average of cell values matching multiple criteria.(Microsoft Excel)
Japanese version.
Average of cell values matching multiple criteria.
The AVERAGEIF function has a single ...
AVERAGEA Function. Get the average including non-numeric values.
Japanese version.
Get the average including non-numeric values.
How it works=AVERAGEA(number1 to 255)NameOmi ...AVERAGE Function. Get the average of the values.
Japanese version.
Get the average of the values.
How it works=AVERAGE(number1 to 255)NameOmissionSpecifynumb ...MODE function. Get mode.(Microsoft Excel)
Function to get the mode.
However, this function has been deprecated, so use the MODE.SNGL function.
MODE.SNGL function and MODE.MULT function. Get mode.(Microsoft Excel)
Get mode (the number that appears most frequently).
FREQUENCY function. Create frequency distribution tables.(Microsoft Excel)
Japanese version.
Function to create a frequency distribution table.
However, it is not easy to use and t ...