Manualsbrain.com
  1. Manuals
  2. Brands
  3. Apple
  4. numbers
  5. User Manual

Apple numbers User Manual

Download
Page of 295
202
Chapter 12
    Dictionary of Functions 
 
Statistical Functions
Statistical functions perform statistical calculations and require numeric expressions as 
arguments. The numeric expression can be a number, cell reference, or range. Unless 
otherwise stated, statistical functions result in a number.
Numbers provides these statistical functions.
Function
Description
Calculates the average difference (deviation) of data points from 
their arithmetic mean (average).
Calculates the average (arithmetic mean) of a set of numbers.
Calculates the average (arithmetic mean) of a set of values 
including numbers, text, and Boolean values.
Returns a value for creating a statistical confidence interval for a 
sample of a specified size from a population with a known 
standard deviation; assumes values in sample are normally 
distributed.
Calculates the correlation between two data sets based on linear 
regression analysis.
Counts the number of arguments and referenced cells that contain 
numbers, numeric expressions, or dates.
Counts the number of arguments and referenced cells that are not 
empty.
Counts the number of cells in a range that are empty.
Counts the number of cells in a range that satisfy a condition.
Calculates the covariance of two data sets.
Calculates the y (dependent) value that corresponds to a chosen x 
(independent) value by using linear regression analysis of known 
value pairs.
Calculates the y-intercept of the best-fit line for a data set using 
linear regression analysis.
Retrieves the nth-largest value in a range.
Finds the largest number in a set.
Finds the largest value in a set that includes numbers, text, and 
Boolean values.
Finds the median value in a set of numbers.
Finds the smallest number in a set.
Finds the smallest value in a set that includes numbers, text, and 
Boolean values.
Finds the most frequently occurring value in a set of numbers.