Function list : Functions - Google Docs Help - 1 views
-
Frequency distribution
- ...21 more annotations...
-
ROUND(number, count)Rounds the given number to a certain number of decimal places according to valid mathematical criteria. Count (optional) is the number of the places to which the value is to be rounded. If the count parameter is negative, only the whole number portion is rounded. It is rounded to the place indicated by the count.
-
AVERAGE(number_1, number_2, ... number_30)Returns the average of the arguments. Number_1, number_2, ... number_30 are numerical values or ranges. Text is ignored.
-
CONFIDENCE(alpha, STDEV, size)Returns the (1-alpha) confidence interval for a normal distribution. Alpha is the level of the confidence interval. STDEV is the standard deviation for the total population. Size is the size of the total population.
-
CORREL(data_1, data_2)Returns the correlation coefficient between two data sets. Data_1 is the first data set. Data_2 is the second data set.
-
COUNT(value_1, value_2, ... value_30)Counts how many numbers are in the list of arguments. Text entries are ignored. Value_1, value_2, ... value_30 are values or ranges which are to be counted.
-
COUNTA(value_1, value_2, ... value_30)Counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored. value_1, value_2, ... value_30 are up to 30 arguments representing the values to be counted.
-
MAX(number_1, number_2, ... number_30)Returns the maximum value in a list of arguments. Number_1, number_2, ... number_30 are numerical values or ranges.
-
MEDIAN(number_1, number_2, ... number_30)Returns the median of a set of numbers. Number_1, number_2, ... number_30 are values or ranges, which represent a sample. Each number can also be replaced by a reference.
-
MIN(number_1, number_2, ... number_30)Returns the minimum value in a list of arguments. Number_1, number_2, ... number_30 are numerical values or ranges.
-
MODE(number_1, number_2, ... number_30)Returns the most common value in a data set. Number_1, number_2, ... number_30 are numerical values or ranges. If several values have the same frequency, it returns the smallest value. An error occurs when a value does not appear twice.
-
PERCENTILE(data, alpha)Returns the alpha-percentile of data values in an array. Data is the array of data. Alpha is the percentage of the scale between 0 and 1.
-
QUARTILE(data, type)Returns the quartile of a data set. Data is the array of data in the sample. Type is the type of quartile. (0 = Min, 1 = 25%, 2 = 50% (Median), 3 = 75% and 4 = Max.)
-
RANK(value, data, type)Returns the rank of the given Value in a sample. Data is the array or range of data in the sample. Type (optional) is the sequence order, either ascending (0) or descending (1).
-
STDEV(number_1, number_2, ... number_30)Estimates the standard deviation based on a sample. Number_1, number_2, ... number_30 are numerical values or ranges representing a sample based on an entire population.
-
STDEVP(number_1, number_2, ... number_30) Calculates the standard deviation based on the entire population. Number_1, number_2, ... number_30 are numerical values or ranges representing a sample based on an entire population.
-
Combines text stringsCONCATENATE(text_1, text_2, ..., text_30)Combines several text strings into one string. Text_1, text_2, ... text_30 are text passages that are to be combined into one string.