Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
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
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!