An array formula works with a series of data values rather than a 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
LINEST Regression statistics based on linear regression through two or more sets of numbers
TREND Numbers in a linear trend, based on known data points
LOGEST Regression statistics based on curvilinear regression through two or more sets of numbers