Statistical Analysis with Excel For Dummies
Book image
Explore Book Buy On Amazon
An array formula calculates a set of values rather than just 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
MODE.MULT Modes of a set of numbers
LINEST Regression statistics based on linear regression through two or more sets of numbers
LOGEST Regression statistics based on curvilinear regression through two or more sets of numbers
TREND Numbers in a linear trend, based on known data points
GROWTH Numbers in a curvilinear trend, based on known data points

About This Article

This article is from the book:

About the book author:

Joseph Schmuller works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of Statistical Analysis with Excel For Dummies.

This article can be found in the category: