Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 12. Statistical Functions

• AVEDEV()

• AVERAGE()

• AVERAGEA()

• AVERAGEIF()

• AVERAGEIFS()

• BETA.DIST()/BETADIST()

• BETA.INV()/BETAINV()

• BINOM.DIST()/BINOMDIST()

• BINOM.INV()/CRITBINOM()

• CHISQ.DIST()

• CHISQ.DIST.RT()/CHIDIST()

• CHISQ.INV()

• CHISQ.INV.RT()/CHIINV()

• CHISQ.TEST()/CHITEST()

• CONFIDENCE.NORM()/CONFIDENCE()

• CONFIDENCE.T()

• CORREL()

• COUNT()

• COUNTA()

• COUNTBLANK()

• COUNTIF()

• COUNTIFS()

• COVAR()

• COVARIANCE.P()

• COVARIANCE.S()

• DEVSQ()

• EXPON.DIST()/EXPONDIST()

• F.DIST()

• F.DIST.RT()/FDIST()

• F.INV()

• F.INV.RT()/FINV()

• F.TEST()/FTEST()

• FISHER()

• FISHERINV()

• FORECAST()

• FREQUENCY()

• GAMMA.DIST()/GAMMADIST()

• GAMMA.INV()/GAMMAINV()

• GAMMALN()

• GAMMALN.PRECISE()

• GEOMEAN()

• GROWTH()

• HARMEAN()

• HYPGEOM.DIST()/HYPGEOMDIST()

• INTERCEPT()

• KURT()

• LARGE()

• LINEST()

• LOGEST()

• LOGNORM.DIST()/LOGNORMDIST()

• LOGNORM.INV()/LOGINV() ...