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

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

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	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

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

 

 

---

© 2004-2018, GrapeCity Inc. All rights reserved.