Statistical functions
At the moment IronCalc only supports a few function in this section.
You can track the progress in this GitHub issue.
| Function | Status | Documentation |
|---|---|---|
| AVEDEV | Not implemented yet | – |
| AVERAGE | Available | – |
| AVERAGEA | Available | – |
| AVERAGEIF | Available | – |
| AVERAGEIFS | Available | – |
| BETA.DIST | Not implemented yet | – |
| BETA.INV | Not implemented yet | – |
| BINOM.DIST | Not implemented yet | – |
| BINOM.DIST.RANGE | Not implemented yet | – |
| BINOM.INV | Not implemented yet | – |
| CHISQ.DIST | Not implemented yet | – |
| CHISQ.DIST.RT | Not implemented yet | – |
| CHISQ.INV | Not implemented yet | – |
| CHISQ.INV.RT | Not implemented yet | – |
| CHISQ.TEST | Not implemented yet | – |
| CONFIDENCE.NORM | Not implemented yet | – |
| CONFIDENCE.T | Not implemented yet | – |
| CORREL | Not implemented yet | – |
| COUNT | Available | – |
| COUNTA | Available | – |
| COUNTBLANK | Available | – |
| COUNTIF | Available | – |
| COUNTIFS | Available | – |
| COVARIANCE.P | Not implemented yet | – |
| COVARIANCE.S | Not implemented yet | – |
| DEVSQ | Not implemented yet | – |
| EXPON.DIST | Not implemented yet | – |
| F.DIST | Not implemented yet | – |
| F.DIST.RT | Not implemented yet | – |
| F.INV | Not implemented yet | – |
| F.INV.RT | Not implemented yet | – |
| F.TEST | Not implemented yet | – |
| FISHER | Not implemented yet | – |
| FISHERINV | Not implemented yet | – |
| FORECAST | Not implemented yet | – |
| FORECAST.ETS | Not implemented yet | – |
| FORECAST.ETS.CONFINT | Not implemented yet | – |
| FORECAST.ETS.SEASONALITY | Not implemented yet | – |
| FORECAST.ETS.STAT | Not implemented yet | – |
| FORECAST.LINEAR | Not implemented yet | – |
| FREQUENCY | Not implemented yet | – |
| GAMMA | Not implemented yet | – |
| GAMMA.DIST | Not implemented yet | – |
| GAMMA.INV | Not implemented yet | – |
| GAMMALN | Not implemented yet | – |
| GAMMALN.PRECISE | Not implemented yet | – |
| GAUSS | Not implemented yet | – |
| GEOMEAN | Available | – |
| GROWTH | Not implemented yet | – |
| HARMEAN | Not implemented yet | – |
| HYPGEOM.DIST | Not implemented yet | – |
| INTERCEPT | Not implemented yet | – |
| KURT | Not implemented yet | – |
| LARGE | Not implemented yet | – |
| LINEST | Not implemented yet | – |
| LOGEST | Not implemented yet | – |
| LOGNORM.DIST | Not implemented yet | – |
| LOGNORM.INV | Not implemented yet | – |
| MAX | Available | – |
| MAXA | Not implemented yet | – |
| MAXIFS | Available | – |
| MEDIAN | Not implemented yet | – |
| MODE.MULT | Not implemented yet | – |
| MODE.SNGL | Not implemented yet | – |
| NEGBINOM.DIST | Not implemented yet | – |
| NORM.DIST | Not implemented yet | – |
| NORM.INV | Not implemented yet | – |
| NORM.S.DIST | Not implemented yet | – |
| NORM.S.INV | Not implemented yet | – |
| PEARSON | Not implemented yet | – |
| PERCENTILE.EXC | Not implemented yet | – |
| PERCENTILE.INC | Not implemented yet | – |
| PERCENTRANK.EXC | Not implemented yet | – |
| PERCENTRANK.INC | Not implemented yet | – |
| PERMUT | Not implemented yet | – |
| PERMUTATIONA | Not implemented yet | – |
| PHI | Not implemented yet | – |
| POISSON.DIST | Not implemented yet | – |
| PROB | Not implemented yet | – |
| QUARTILE.EXC | Not implemented yet | – |
| QUARTILE.INC | Not implemented yet | – |
| RANK.AVG | Not implemented yet | – |
| RANK.EQ | Not implemented yet | – |
| RSQ | Not implemented yet | – |
| SKEW | Not implemented yet | – |
| SKEW.P | Not implemented yet | – |
| SLOPE | Not implemented yet | – |
| SMALL | Not implemented yet | – |
| STANDARDIZE | Not implemented yet | – |
| STDEV.P | Not implemented yet | – |
| STDEV.S | Not implemented yet | – |
| STDEVA | Not implemented yet | – |
| STDEVPA | Not implemented yet | – |
| STEYX | Not implemented yet | – |
| T.DIST | Not implemented yet | – |
| T.DIST.2T | Not implemented yet | – |
| T.DIST.RT | Not implemented yet | – |
| T.INV | Not implemented yet | – |
| T.INV.2T | Not implemented yet | – |
| T.TEST | Not implemented yet | – |
| TREND | Not implemented yet | – |
| TRIMMEAN | Not implemented yet | – |
| VAR.P | Not implemented yet | – |
| VAR.S | Not implemented yet | – |
| VARA | Not implemented yet | – |
| VARPA | Not implemented yet | – |
| WEIBULL.DIST | Not implemented yet | – |
| Z.TEST | Not implemented yet | – |