21.Statistical functions | ||
21.1.AVERAGE( 4 ) | 21.42.LOGINV( 1 ) | |
21.2.AVERAGEA( 2 ) | 21.43.LOGNORMDIST( 1 ) | |
21.3.AVERAGEIF( 3 ) | 21.44.MAX( 2 ) | |
21.4.AVERAGEIFS( 2 ) | 21.45.MAXA( 1 ) | |
21.5.BETADIST( 1 ) | 21.46.MEDIAN( 1 ) | |
21.6.CHIDIST( 1 ) | 21.47.MIN( 2 ) | |
21.7.CHIINV( 1 ) | 21.48.MINA( 1 ) | |
21.8.CHITEST( 1 ) | 21.49.MODE( 1 ) | |
21.9.CONFIDENCE( 1 ) | 21.50.NEGBINOMDIST( 1 ) | |
21.10.CORREL( 1 ) | 21.51.NORMDIST( 2 ) | |
21.11.COUNT( 3 ) | 21.52.NORMINV( 1 ) | |
21.12.COUNTA( 4 ) | 21.53.NORMSDIST( 1 ) | |
21.13.COUNTBLANK( 3 ) | 21.54.NORMSINV( 1 ) | |
21.14.COUNTIF( 7 ) | 21.55.PEARSON( 1 ) | |
21.15.COUNTIFS( 2 ) | 21.56.PERCENTILE( 1 ) | |
21.16.COVAR( 1 ) | 21.57.PERCENTRANK( 1 ) | |
21.17.CRITBINOM( 1 ) | 21.58.PERMUT( 1 ) | |
21.18.DATEVALUE( 4 ) | 21.59.POISSON( 2 ) | |
21.19.DAY( 1 ) | 21.60.PROB( 2 ) | |
21.20.DAYS360( 1 ) | 21.61.QUARTILE( 3 ) | |
21.21.DEVSQ( 1 ) | 21.62.RANK( 1 ) | |
21.22.EXPONDIST( 2 ) | 21.63.RSQ( 1 ) | |
21.23.FDIST( 1 ) | 21.64.SKEW( 1 ) | |
21.24.FINV( 1 ) | 21.65.SLOPE( 1 ) | |
21.25.FISHER( 1 ) | 21.66.SMALL( 1 ) | |
21.26.FISHERINV( 1 ) | 21.67.STANDARDIZE( 1 ) | |
21.27.FORECAST( 1 ) | 21.68.STDEV( 1 ) | |
21.28.FREQUENCY( 1 ) | 21.69.STDEVA( 2 ) | |
21.29.FTEST( 1 ) | 21.70.STDEVP( 1 ) | |
21.30.GAMMADIST( 2 ) | 21.71.STEYX( 1 ) | |
21.31.GAMMAINV( 1 ) | 21.72.TDIST( 1 ) | |
21.32.GAMMALN( 1 ) | 21.73.TINV( 1 ) | |
21.33.GEOMEAN( 1 ) | 21.74.TREND( 1 ) | |
21.34.GROWTH( 1 ) | 21.75.TRIMMEAN( 1 ) | |
21.35.HARMEAN( 1 ) | 21.76.TTEST( 1 ) | |
21.36.HYPGEOMDIST( 1 ) | 21.77.VAR( 1 ) | |
21.37.INTERCEPT( 1 ) | 21.78.VARA( 1 ) | |
21.38.KURT( 1 ) | 21.79.VARP( 1 ) | |
21.39.LARGE( 1 ) | 21.80.VARPA( 1 ) | |
21.40.LINEST( 1 ) | 21.81.WEIBULL( 2 ) | |
21.41.LOGEST( 1 ) | 21.82.ZTEST( 2 ) |