• # Statistical

• ## PERCENTRANK.INC

Returns the rank of a number, as a percentage (0..1 inclusive), in a given list of numbers.   Syntax   PERCENTRANK.INC(number_list; number; [significance]) number_list: The array or range containing the list of numbers to evaluate. Eg., A2:A6 number: ...
• ## PERCENTRANK.EXC

Returns the rank of a number, as a percentage (0..1 exclusive), in a given list of numbers.   Syntax   PERCENTRANK.EXC(number_list; number; [significance]) number_list: The array or range containing the list of numbers to evaluate. Eg., A2:A6 number: ...
• ## PERCENTILE.INC

Returns the value for a given percentile that ranges between 0 and 1, inclusive, from the specified data range.   Syntax   PERCENTILE.INC(number_list; fraction) number_list: Range or array of numbers to evaluate. Eg., A2:A6 percentile: The percentile ...
• ## PERCENTILE.EXC

Returns the value for a given percentile that ranges between 0 and 1, exclusive, from the specified data range.   Syntax PERCENTILE.EXC(number_list; fraction) number_list: Range or array of numbers to evaluate. Eg., A2:A6 percentile: The percentile ...
• ## QUARTILE.INC

Returns the value for a specified quartile in a given data set based on percentile values from 0 to1, inclusive.   Syntax QUARTILE.INC(number_list; q) number_list: The data set given as input. Eg., A2:A6 q: The quartile number whose data you want. ...
• ## QUARTILE.EXC

Returns the value for a specified quartile in a given data set based on percentile values from 0 to1, exclusive.   Syntax QUARTILE.EXC(number_list; q) number_list: The data set given as input. Eg., A2:A6 q: The quartile number whose data you want. ...
• ## TREND

Predicts future values for an ideal straight line based on the given data set.   Syntax   TREND(y_values; [x_values]; [new_x_values]; [type]) y_values: The array or range containing the known (dependent) y values. E.g. B2:B11 x_values: The array or ...
• ## LOGEST

Returns an array of statistics for an exponential curve that best fits the given data set.   Syntax   LOGEST(y_values; [x_values]; [allow_const]; [stats]) y_values: The array or range containing the known (or dependent) y values. E.g. A2:A6 x_values: ...
• ## LINEST

Returns an array of statistics for a straight line that best fits the given data set.   Syntax   LINEST(y_values; [x_values]; [allow_const]; [stats]) y_values: The array or range containing the known (or dependent) y values. E.g. A2:A6 x_values: The ...
• ## GROWTH

Returns an ideal exponential curve or predicts further values that best fit the given data set.   Syntax   GROWTH(y_values; [x_values]; [new_x_values]; [allow_factor]) y_values: The array or range containing the known (or dependent) y values. E.g. ...
• ## FREQUENCY

Returns an array categorizing data in the given intervals, based on the occurrence of values in the data.   Syntax   FREQUENCY(data; bins) data: The data to categorize. E.g. A2:A8 bins: A single column range or array into which you want to categorize ...
• ## ZTEST

Returns the result of a z-test. Calculates the likelihood that the sample mean is greater than the observed mean.   Syntax   ZTEST(data; μ ;[σ]) data: The array or range containing the data set. Eg., A2:A8 μ: Arithmetic mean of the distribution. Eg., ...
• ## WEIBULL

Calculates values for a Weibull distribution based on the specified shape and scale.   Syntax   WEIBULL(x; k; λ; mode) x: The number at which you want to find the Weibull distribution. Eg., 100 k: The shape parameter of the distribution. Eg., 15 λ: ...
• ## VARPA

Returns the variance based on an entire population, including text and logical values.   Syntax   VARPA(number; [number1]; ...) number: The numbers or range containing the population whose variance you want. Eg., A2:A8   Remarks The logical ...
• ## VARP

Returns the variance based on an entire population.   Syntax   VARP(number; [number1]; ...) number: The numbers or range containing the population whose variance you want. Eg., A2:A8   Examples   Formula Result =VARP(A2:A8) 22665.583333333 ...
• ## VARA

Returns the variance based on a given sample, including text and logical values.   Syntax   VARA(number; [number1]; ...) number: The numbers or range containing the numbers whose variance you want. Eg., A2:A8   Remarks The logical expression TRUE is ...
• ## VAR

Returns the variance based on a given sample. Syntax   VAR(number; [number1]; ...) number: The numbers or range containing the numbers you want the variance of. Eg., A2:A8   Remarks Text, logical values, and empty cells are ignored. Examples   ...
• ## UNIQUE

Returns the unique values from a given range or array of values.   Syntax   UNIQUE(range; [col]; [occurs_once]) range: The array of values or cell range to evaluate. Eg., A2:A16 col: Indicates how to compare the given values. Defaults to FALSE if ...
• ## TTEST

Returns the probability associated with a T-test. Calculates the likelihood that two samples have come from the same two underlying populations having the same mean.   Syntax   TTEST(data1; data2; mode; type) data1: The first array or data range. ...
• ## TRIMMEAN

Returns the mean of a given set of numbers, ignoring a specified proportion of high and low values.   Syntax   TRIMMEAN(number_list; fraction) number_list: The range containing the data set to trim and average. Eg., A2:A10 fraction: The fractional ...
• ## TINV

Returns the inverse of the two-tailed Student's t-distribution.   Syntax   TINV(p; r) p: The probability associated with the two-tailed Student's t-distribution. Eg., 0.00001671789032 r: The number of degrees of freedom. Eg., 5   Examples   Formula ...
• ## TDIST

Calculates values for a Student's t-distribution based on a given value.   Syntax   TDIST(x; r; mode) x: The value at which to calculate the distribution. Eg., 14 r: The number of degrees of freedom. Eg., 5 mode: Specifies the type of distribution. 1 ...
• ## STEYX

Returns the standard error of the predicted y value for each x in the regression.   Syntax   STEYX(y_values; x_values) y_values: The array or range containing the known (dependent) values. Eg., A2:A6 x_values: The array or range containing the known ...
• ## STDEVPA

Returns the standard deviation based on the entire population, considering text values as 0.   Syntax   STDEVPA(number; [number1]; ...) number: The numbers or range containing the population you want the standard deviation of. Eg., A2:A8 Remarks The ...
• ## STDEVP

Returns the standard deviation based on the entire population.   Syntax   STDEVP(number; [number1]; ...) number: The numbers or range containing the population you want the standard deviation of. Eg., A2:A8   Remarks The logical expression TRUE is ...
• ## STDEVA

Returns the standard deviation based on the given sample, considering text values as 0.   Syntax   STDEVA(number; [number1]; ...) number: The numbers you want the standard deviation of. Eg., A2:A8   Remarks The logical expression TRUE is considered ...
• ## STDEV

Returns the standard deviation based on the given sample.   Syntax   STDEV(number; [number1]; ...) number: The numbers that you want the standard deviation of. Eg., A2:A8   Remarks Text, logical values, and empty cells are ignored. Examples   Formula ...
• ## STANDARDIZE

Converts a random variable into a normalized variable, given its mean and standard deviation.   Syntax   STANDARDIZE(n; μ; σ) n: The value to normalize. Eg., 14 μ: Arithmetic mean of the distribution. Eg., 5 σ: The standard deviation of the ...
• ## SMALL

Returns the nth smallest number in a given range or array of numbers.   Syntax   SMALL(number_list; n) number_list: The array or range containing the numbers to test. Eg., A2:A10 n: The position, from the smallest, in the given data to return. Eg., 2 ...
• ## SLOPE

Returns the slope of a straight line from the linear regression of the given data set.   Syntax   SLOPE(y_values; x_values) y_values: The array or range containing the known (dependent) values. Eg., A2:A6 x_values: The array or range containing the ...
• ## SKEW

Returns the skewness of a given data set. The skewness describes the degree of asymmetry of the distribution around its mean. Positive and negative values indicate a distribution with the tail inclining more towards the positive side and negative ...
• ## RSQ

Returns the square of the Pearson product moment correlation coefficient, r, of the given data sets.   Syntax   RSQ(x; y) x: Range or array containing the first data set. Eg., A2:A6 y: Range or array containing the second data set. Eg., B2:B6   ...
• ## RANK.EQ

Returns the rank of a given number from the specified list of numbers. If the number occurs more than once in the list, the top rank is returned.   Syntax   RANK.EQ(number; number_list; [order]) number: The number that you want to calculate the rank ...
• ## RANK.AVG

Returns the rank of a given number from the specified list of numbers. If the number occurs more than once in the list, the average rank is returned.   Syntax   RANK.AVG(number; number_list; [order]) number: The number that you want to calculate the ...
• ## RANK

Returns the rank of a number in a given list of numbers.   Syntax   RANK(number; number_list; [order]) number: The number that you want to calculate the rank of. Eg., 51 number_list: The array or range containing the list of numbers to evaluate. Eg., ...
• ## QUARTILE

Returns the value for a specified quartile in a given data set.   Syntax   QUARTILE(number_list; q) number_list: The data set given as input. Eg., A2:A6 q: The quartile number whose data you want. 0 - Minimum value (0%) 1 - First quartile (25%) 2 - ...
• ## PROB

Calculates the probability that a random value chosen falls between two given limits.   Syntax   PROB(values; probabilities; [start]; [end]) values: A range or array of numbers. Eg., A2:A5 probabilities: A range or array of numbers of the same size ...
• ## POISSON

Returns the Poisson distribution for a specified value at a given mean. The Poisson distribution predicts the number of events that occur in a specified time.   Syntax   POISSON(x; λ; mode) x: The value at which you want to calculate the Poisson ...
• ## PHI

Calculates probability density function for a standard normal distribution.   Syntax   PHI(x) x: Number for which you want to calculate the density of the standard normal distribution. Eg., 0.25   Remarks Empty cells are considered as 0. Examples   ...
• ## PERMUTATIONA

Returns the number of ordered permutations for a specified number of objects to be selected from the given number of objects, allowing repetitions.   Syntax   PERMUTATIONA(n; k) n: The total number of objects. Eg., 10 k: The number of objects to ...