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
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
Statistical Analysis with Excel For Dummies Cheat Sheet

Advertisement

Inside Dummies.com