ExcelFunctions.net

Search Site:

Excel 2010 provides several new functions that were previously not available in earlier versions of Excel. Most of these are statistical functions, although many of these are simply updated versions of older Excel functions.

The new Excel 2010 functions are listed below, organised by category.

Date & Time Functions | |
---|---|

WORKDAY.INTL | Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date, using supplied parameters to specify weekend days. |

NETWORKDAYS.INTL | Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days. |

Math Functions | |
---|---|

AGGREGATE | Performs a specified calculation (e.g. the sum, product, average, etc.) for a list or database, with the option to ignore hidden rows and error values. |

CEILING.PRECISE | Rounds a number up, regardless of the sign of the number, to a multiple of significance. |

ISO.CEILING | Rounds a number up, regardless of the sign of the number, to a multiple of significance. |

FLOOR.PRECISE | Rounds a number down, regardless of the sign of the number, to a multiple of significance. |

Statistical Functions | |
---|---|

PERCENTILE.INC | Returns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (inclusive) (Replaces the old Percentile function). |

PERCENTILE.EXC | Returns the K'th percentile of values in a supplied range, where K is in the range 0 - 1 (exclusive). |

QUARTILE.INC | Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (inclusive) (Replaces the old Quartile function). |

QUARTILE.EXC | Returns the specified quartile of a set of supplied numbers, based on percentile value 0 - 1 (exclusive). |

RANK.EQ | Returns the Mode (the most frequently occurring value) of a list of supplied numbers (if more than one value has same rank, the top rank of that set is returned) (Replaces the old Rank function). |

RANK.AVG | Returns the statistical rank of a given value, within a supplied array of values (if more than one value has same rank, the average rank is returned). |

PERCENTRANK.INC | Returns the rank of a value in a data set, as a percentage (0 - 1 inclusive) (Replaces the old Percentrank function). |

PERCENTRANK.EXC | Returns the rank of a value in a data set, as a percentage (0 - 1 exclusive). |

MODE.SNGL | Returns the Mode (the most frequently occurring value) of a list of supplied numbers (Replaces the old Mode function). |

MODE.MULT | Returns a vertical array of the most frequently occurring values in an array or range of data. |

STDEV.S | Returns the standard deviation of a supplied set of values (which represent a sample of a population) (Replaces the old Stdev function). |

STDEV.P | Returns the standard deviation of a supplied set of values (which represent an entire population) (Replaces the old Stdevp function). |

VAR.S | Returns the variance of a supplied set of values (which represent a sample of a population) (Replaces the old Var function). |

VAR.P | Returns the variance of a supplied set of values (which represent an entire population) (Replaces the old Varp function). |

COVARIANCE.P | Returns population covariance (i.e. the average of the products of deviations for each pair within two supplied data sets) (Replaces the old Covar function). |

COVARIANCE.S | Returns sample covariance (i.e. the average of the products of deviations for each pair within two supplied data sets). |

CONFIDENCE.NORM | Returns the confidence interval for a population mean, using a normal distribution (Replaces the old Confidence function). |

CONFIDENCE.T | Returns the confidence interval for a population mean, using a Student's t distribution. |

BETA.DIST | Returns the cumulative beta distribution function or the beta probability density function (Replaces the old Betadist function). |

BETA.INV | Returns the inverse of the cumulative beta probability density function (Replaces the old Betainv function). |

BINOM.DIST | Returns the individual term binomial distribution probability (Replaces the old Binomdist function). |

NEGBINOM.DIST | Returns the negative binomial distribution (Replaces the old Negbinomdist function). |

BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value (Replaces the old Critbinom function). |

CHISQ.DIST.RT | Returns the right-tailed probability of the chi-squared distribution (Replaces the old Chidist function). |

CHISQ.DIST | Returns the chi-squared distribution (probability density or cumulative distribution function). |

CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution (Replaces the old Chiinv function). |

CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution. |

CHISQ.TEST | Returns the chi-squared statistical test for independence (Replaces the old Chitest function). |

EXPON.DIST | Returns the exponential distribution (Replaces the old Expondist function). |

F.DIST | Returns the F probability distribution (probability density or cumulative distribution function). |

F.INV.RT | Returns the inverse of the right-tailed F probability distribution for two data sets (Replaces the old Finv function). |

F.INV | Returns the inverse of the Cumulative F distribution. |

F.TEST | Returns the result of an F-Test for 2 supplied data sets (Replaces the old Ftest function). |

GAMMA.DIST | Returns the gamma distribution (Replaces the old Gammadist function). |

GAMMA.INV | Returns the inverse gamma cumulative distribution (Replaces the old Gammainv function). |

GAMMALN.PRECISE | Returns the natural logarithm of the gamma function for a supplied value. |

HYPGEOM.DIST | Returns the hypergeometric distribution (Replaces the old Hypgeomdist function). |

LOGNORM.DIST | Returns the log-normal probability density function or the cumulative log- normal distribution (Replaces the old Lognormdist function). |

LOGNORM.INV | Returns the inverse of the lognormal distribution (Replaces the old Loginv function). |

NORM.DIST | Returns the normal cumulative distribution (Replaces the old Normdist function). |

NORM.INV | Returns the inverse of the normal cumulative distribution (Replaces the old Norminv function). |

NORM.S.DIST | Returns the standard normal cumulative distribution (Replaces the old Normsdist function). |

NORM.S.INV | Returns the inverse of the standard normal cumulative distribution (Replaces the old Normsinv function). |

POISSON.DIST | Returns the Poisson distribution (Replaces the old Poisson function). |

T.DIST.2T | Returns the two-tailed Student's T-distribution (Replaces the old Tdist function). |

T.DIST.RT | Returns the right-tailed Student's T-distribution (Replaces the old Tdist function). |

T.DIST | Returns the Student's T-distribution (probability density or cumulative distribution function). |

T.INV.2T | Returns the two-tailed inverse of the Student's T-distribution (Replaces the old Tinv function). |

T.INV | Returns the left-tailed inverse of the Student's T-distribution. |

T.TEST | Returns the probability associated with a Student's T-Test (Replaces the old Ttest function). |

WEIBULL.DIST | Returns the Weibull distribution (Replaces the old Weibull function). |

Z.TEST | Returns the one-tailed probability value of a z-test (Replaces the old Ztest function). |

Engineering Functions | |
---|---|

ERF.PRECISE | Returns the error function integrated between 0 and a supplied limit. |

ERFC.PRECISE | Returns the complementary error function integrated between a supplied lower limit and infinity. |