すべて折りたたむ 全て展開

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

AVEDEV	AVERAGE	AVERAGEA	AVERAGEIF
AVERAGEIFS	BETA.DIST	BETA.INV	BETADIST
BETAINV	BINOM.DIST	BINOM.DIST.RANGE	BINOM.INV
BINOMDIST	CHIDIST	CHIINV	CHISQ.DIST
CHISQ.DIST.RT	CHISQ.INV	CHISQ.INV.RT	CHISQ.TEST
CHITEST	CONFIDENCE	CONFIDENCE.NORM	CONFIDENCE.T
CORREL	COUNT	COUNTA	COUNTIF
COUNTIFS	COVAR	COVARIANCE.P	COVARIANCE.S
CRITBINOM	DEVSQ	EXPON.DIST	EXPONDIST
F.DIST	F.DIST.RT	F.INV	F.INV.RT
F.TEST	FDIST	FINV	FISHER
FISHERINV	FORECAST	FREQUENCY	FTEST
GAMMA	GAMMA.DIST	GAMMA.INV	GAMMADIST
GAMMAINV	GAMMALN	GAMMALN.PRECISE	GAUSS
GEOMEAN	GROWTH	HARMEAN	HYPGEOMDIST
HYPGEOMDIST	INTERCEPT	KURT	LARGE
LINEST	LOGEST	LOGINV	LOGNORM.DIST
LOGNORM.INV	LOGNORMDIST	MAX	MAXA
MAXIFS	MEDIAN	MIN	MINA
MINIFS	MODE	MODE.MULT	MODE.SNGL
NEGBINOM.DIST	NEGBINOMDIST	NORM.DIST	NORM.S.DIST
NORM.S.INV	NORMDIST	NORMINV	NORMSDIST
NORMSINV	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	STDEV.P
STDEV.S	STDEVA	STDEVP	STDEVPA
STEYX	T.DIST	T.DIST.2T	T.DIST.RT
T.INV	T.INV.2T	T.TEST	TDIST
TINV	TREND	TRIMMEAN	TTEST
VAR	VAR.P	VAR.S	VARA
VARP	VARPA	WEIBULL	WEIBULL.DIST
Z.TEST	ZTEST

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

 

 

---

Copyright © 2012 GrapeCity inc. All rights reserved.