# Excel Array Functions for Statistical Analysis

An array formula calculates a set of values rather than just one. Here are Excel’s statistical array functions. Each one returns an array of values into a selected array of cells.

Function | Calculates An Array Of … |

FREQUENCY | Frequencies of values in a set of values |

MODE.MULT | Modes of a set of numbers |

LINEST | Regression statistics based on linear regression through two or more sets of numbers |

LOGEST | Regression statistics based on curvilinear regression through two or more sets of numbers |

TREND | Numbers in a linear trend, based on known data points |

GROWTH | Numbers in a curvilinear trend, based on known data points |