Excel Array Functions
Part of the Statistical Analysis with Excel For Dummies Cheat Sheet
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 |
