Excel Array Functions
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|