Online Test Banks
Score higher
See Online Test Banks
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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

Statistical Analysis with Excel For Dummies Cheat Sheet


Inside Sweepstakes

Win $500. Easy.