This appendix contains a complete listing of Excel worksheet functions. The functions are arranged alphabetically by the categories displayed in the Insert Function dialog box.

For more information about a particular function, including its arguments, select the function in the Insert Function dialog box and then click Help on This Function.

NOTE

An interactive workbook that contains this information is available on the companion CD-ROM. The filename is `worksheet functions.xlsx`.

Function | What It Does |
---|---|

BETADIST | Returns the cumulative beta probability density function. |

BETAINV | Returns the inverse of the cumulative beta probability density function. |

BINOMDIST | Returns the individual term binomial distribution probability. |

CHIDIST | Returns the one-tailed probability of the chi-squared distribution. |

CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution. |

CHITEST | Returns the test for independence. |

CONFIDENCE | Returns the confidence interval for a population mean. |

COVAR | Returns covariance, the average of the products of paired deviations. |

CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |

EXPONDIST | Returns the exponential distribution. |

FDIST | Returns the F probability distribution. |

FINV | Returns the inverse of the F probability distribution. |

FTEST | Returns the result of an F-Test. |

GAMMADIST | Returns the gamma distribution. |

GAMMAINV ... |

Start Free Trial

No credit card required