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 range ...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: The ...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. B2:B11 ...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 as ...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 Formula ...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 choose. ...Next page
Access your files securely from anywhere
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?