MESCIUS SPREAD for WPF 4.0J 関数リファレンス
統計関数
数式の概要 > 数式での関数の使用 > 関数の種類 > 統計関数

以下は、統計演算に関する関数です。

AVEDEV AVERAGE AVERAGEA AVERAGEIF
AVERAGEIFS BETADIST BETA.DIST BETAINV
BETA.INV BINOMDIST BINOM.DIST BINOM.DIST.RANGE
BINOM.INV CHIDIST CHIINV CHISQ.DIST
CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST
CHITEST CONFIDENCE CONFIDENCE.NORM CONFIDENCE.T
CORREL COUNT COUNTIF COUNTIFS
COUNTA COVAR COVARIANCE.P COVARIANCE.S
CRITBINOM DEVSQ EXPONDIST EXPON.DIST
FDIST F.DIST F.DIST.RT FINV
F.INV F.INV.RT FISHER FISHERINV
FORECAST FORECAST.LINEAR FREQUENCY FTEST
F.TEST GAMMA GAMMADIST GAMMA.DIST
GAMMAINV GAMMA.INV GAMMALN GAMMALN.PRECISE
GAUSS GEOMEAN GROWTH HARMEAN
HYPGEOMDIST HYPGEOM.DIST INTERCEPT KURT
LARGE LINEST LOGEST LOGINV
LOGNORMDIST LOGNORM.DIST LOGNORM.INV MAX
MAXA MAXIFS MEDIAN MIN
MINA MINIFS MODE MODE.MULT
MODE.SNGL NEGBINOMDIST NEGBINOM.DIST NORMDIST
NORM.DIST NORMINV NORM.INV NORMSDIST
NORM.S.DIST NORMSINV NORM.S.INV PEARSON
PERCENTILE PERCENTILE.EXC PERCENTILE.INC PERCENTRANK
PERCENTRANK.EXC PERCENTRANK.INC PERMUT PERMUTATIONA
PHI POISSON POISSON.DIST PROB
QUARTILE QUARTILE.EXC QUARTILE.INC RANK
RANK.AVG RANK.EQ RSQ SKEW
SKEW. P SLOPE SMALL STANDARDIZE
STDEV STDEVA STDEVP STDEV.P
STDEVPA STDEV.S STEYX TDIST
T.DIST T.DIST.2T T.DIST.RT TINV
T.INV T.INV.2T TREND TRIMMEAN
TTEST T.TEST VAR VARA
VARP VAR.P VARPA VAR.S
WEIBULL WEIBULL.DIST ZTEST Z.TEST  

関数の種類の一覧については、「関数の種類」を参照してください。