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 |
