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 | Available | – |
| AVERAGE | Available | – |
| AVERAGEA | Available | – |
| AVERAGEIF | Available | – |
| AVERAGEIFS | Available | – |
| BETA.DIST | Available | – |
| BETA.INV | Available | – |
| BINOM.DIST | Available | – |
| BINOM.DIST.RANGE | Available | – |
| BINOM.INV | Available | – |
| CHISQ.DIST | Available | – |
| CHISQ.DIST.RT | Available | – |
| CHISQ.INV | Available | – |
| CHISQ.INV.RT | Available | – |
| CHISQ.TEST | Available | – |
| CONFIDENCE.NORM | Available | – |
| CONFIDENCE.T | Available | – |
| CORREL | Available | – |
| COUNT | Available | – |
| COUNTA | Available | – |
| COUNTBLANK | Available | – |
| COUNTIF | Available | – |
| COUNTIFS | Available | – |
| COVARIANCE.P | Available | – |
| COVARIANCE.S | Available | – |
| DEVSQ | Available | – |
| EXPON.DIST | Available | – |
| F.DIST | Available | – |
| F.DIST.RT | Available | – |
| F.INV | Available | – |
| F.INV.RT | Available | – |
| F.TEST | Available | – |
| FISHER | Available | – |
| FISHERINV | Available | – |
| 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 | Available | – |
| GAMMA.DIST | Available | – |
| GAMMA.INV | Available | – |
| GAMMALN | Available | – |
| GAMMALN.PRECISE | Available | – |
| GAUSS | Available | – |
| GEOMEAN | Available | – |
| GROWTH | Not implemented yet | – |
| HARMEAN | Available | – |
| HYPGEOM.DIST | Available | – |
| INTERCEPT | Available | – |
| KURT | Available | – |
| LARGE | Available | – |
| LINEST | Not implemented yet | – |
| LOGEST | Not implemented yet | – |
| LOGNORM.DIST | Available | – |
| LOGNORM.INV | Available | – |
| MAX | Available | – |
| MAXA | Available | – |
| MAXIFS | Available | – |
| MEDIAN | Not implemented yet | – |
| MIN | Available | – |
| MINA | Available | – |
| MINIFS | Available | – |
| MODE.MULT | Not implemented yet | – |
| MODE.SNGL | Not implemented yet | – |
| NEGBINOM.DIST | Available | – |
| NORM.DIST | Available | – |
| NORM.INV | Available | – |
| NORM.S.DIST | Available | – |
| NORM.S.INV | Available | – |
| PEARSON | Available | – |
| 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 | Available | – |
| POISSON.DIST | Available | – |
| PROB | Not implemented yet | – |
| QUARTILE.EXC | Not implemented yet | – |
| QUARTILE.INC | Not implemented yet | – |
| RANK.AVG | Available | – |
| RANK.EQ | Available | – |
| RSQ | Available | – |
| SKEW | Available | – |
| SKEW.P | Available | – |
| SLOPE | Available | – |
| SMALL | Available | – |
| STANDARDIZE | Available | – |
| STDEV.P | Available | – |
| STDEV.S | Available | – |
| STDEVA | Available | – |
| STDEVPA | Available | – |
| STEYX | Available | – |
| T.DIST | Available | – |
| T.DIST.2T | Available | – |
| T.DIST.RT | Available | – |
| T.INV | Available | – |
| T.INV.2T | Available | – |
| T.TEST | Available | – |
| TREND | Not implemented yet | – |
| TRIMMEAN | Not implemented yet | – |
| VAR.P | Available | – |
| VAR.S | Available | – |
| VARA | Available | – |
| VARPA | Available | – |
| WEIBULL.DIST | Available | – |
| Z.TEST | Available | – |