MESCIUS SPREAD for Windows Forms 15.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 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  

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

 

 


© MESCIUS inc. All rights reserved.