Statistical
PERMUT
Returns the number of ordered permutations for a specified number of objects to be selected from the given number of objects. Syntax PERMUT(n; k) n: The total number of objects. Eg., 10 k: The number of objects to choose. Eg., 2 Examples Formula ...PERCENTRANK
Returns the rank of a number, as a percentage, in a given list of numbers. Syntax PERCENTRANK(number_list; number; [significance]) number_list: The array or range containing the list of numbers to evaluate. Eg., A2:A6 number: The number that you ...PERCENTILE
Returns the value for a given percentile from the specified data range. Syntax PERCENTILE(number_list; fraction) number_list: Range or array of numbers to evaluate. Eg., A2:A6 percentile: The percentile value from 0 to 1, inclusive. Eg., 0.2 ...PEARSON
Returns the Pearson product moment correlation coefficient, r, of the given data sets. Syntax PEARSON(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 Remarks Text, logical ...NORMSINV
Calculates the inverse standard normal distribution function for a specified value, with mean as 0 and standard deviation as 1. Syntax NORMSINV(p) p: The probability corresponding to the normal distribution. Eg., 0.25 Examples Formula Result ...NORMSDIST
Returns the value of the standard normal cumulative distribution function for a specified value, with mean as 0 and standard deviation as 1. Syntax NORMSDIST(x) x: The value that you want the distribution for. Eg., 14 Examples Formula Result ...NORMINV
Returns the inverse of the cumulative normal distribution for a given mean and standard deviation. Syntax NORMINV(p; μ; σ) p: Probability corresponding to a normal distribution. Eg., 0.000007992 μ: Arithmetic mean of the distribution. Eg., 5 σ: ...NORMDIST
Returns the normal distribution function for the given mean and standard deviation, for a specified value. Syntax NORMDIST(x; μ; σ; mode) x: The value for which you want the normal distribution. Eg., 14 μ: Arithmetic mean of the distribution. Eg., 5 ...NEGBINOMDIST
Calculates the probability of getting 'x' failures before reaching the r th success for independent trials with the probability of success 'p'. Syntax NEGBINOMDIST(x; r; p) x: The number of failures to obtain probability for. Eg., 10 r: The number of ...MODE
Returns the most frequently occurring value in a given data set. If two numbers occur the same (maximum) number of times, MODE returns the first occurring number. Syntax MODE(value; [value1]; ...) value: The range or array containing the data set to ...MINIFS
Returns the minimum value from a given list of arguments, based on the specified conditions. Syntax MINIFS(min_range; condition_range; condition;[condition_range1]; [condition1];...) min_range: The source range to find the minimum value. Eg., B2:B7 ...MINA
Returns the minimum value from a given list of arguments, including text and logical entries. Syntax MINA(value; [value1]; ...) value: The values, including text, given as input. Eg., A2:A6 Remarks Text is evaluated as 0, while logical values are ...MIN
Returns the minimum value from a given list of arguments, ignoring text entries. Syntax MIN(number; [number1]; ...) number: The numbers given as input. Eg., A2:A6 Remarks The MIN function returns 0 if there are no numbers in the given input. Examples ...MEDIAN
Returns the median of the given numbers. The median is the number in the middle of the given set. Syntax MEDIAN(number; [number1]; ...) number: The numbers that you want to calculate the median of. Eg., A2:A6 Remarks If the given set has even number ...MAXIFS
Returns the maximum value from the given list of arguments, based on the specified conditions. Syntax MAXIFS(max_range; condition_range; condition; [condition_range1]; [condition1];...) max_range: The source range to find the maximum value. Eg., ...MAXA
Returns the maximum value from the given list of arguments, including text and logical entries. Syntax MAXA(value; [value1]; ...) value: The values, including text, given as input. Eg., A2:A6 Remarks Text is evaluated as 0, while logical values are ...MAX
Returns the maximum value from the given list of arguments, ignoring text entries. Syntax MAX(number; [number1]; ...) number: The numbers given as input. Eg., A2:A6 Remarks The MAX function returns 0 if there are no numbers in the given input. ...LOGNORMDIST
Returns the values of the lognormal cumulative distribution for a given mean and standard deviation, at a specified value. Syntax LOGNORMDIST(x; μ; σ) x: The value to evaluate the function at. Eg., 25.947598893 μ: The mean of the logarithmic ...LOGINV
Returns the inverse of lognormal cumulative distribution for a given mean and standard deviation, at a specified value. Syntax LOGINV(p; μ ; σ) p: Probability value that you want to calculate the inverse logarithmic distribution for. Eg., 0.3 μ: The ...LARGE
Returns the nth largest number in a given range or array of numbers. Syntax LARGE(number_list; n) number_list: The array or range containing the numbers to test. Eg., A2:A10 n: The position, from the largest number, in the given data to return. Eg., ...KURT
Returns the kurtosis, a measure of how peaked or flat a distribution is, compared to a normal distribution. Positive values indicate a relatively peaked distribution, while negative values indicate a relatively flat distribution. Syntax KURT(number; ...INTERCEPT
Calculates the point at which a line, obtained using linear regression, will intersect the y-axis (i.e. x=0) with the given x-values and y-values. Syntax INTERCEPT(y_values; x_values) y_values: The dependent set of observations or data. Eg., A2:A6 ...HYPGEOMDIST
Returns the hypergeometric distribution, i.e., the probability of 'x' successes from 'n' number of draws for a given population 'N' with 'M' number of successes, without replacement of draws. Syntax HYPGEOMDIST(x; n; M; N) x: The number of successes ...HARMEAN
Returns the harmonic mean of the given arguments. Syntax HARMEAN(number; [number1]; ...) number: Numbers or range containing the data whose harmonic mean you want to calculate. Eg., A2:A6 Examples Formula Result =HARMEAN(A2:A6) 6.781485468 ...GEOMEAN
Returns the geometric mean of the given data set. Syntax GEOMEAN(number; [number1]; ...) number: Numbers or range containing data whose geometric mean you want to calculate. Eg., A2:A6 Examples Formula Result =GEOMEAN(A2:A6) 8.060219369 ...GAUSS
Returns the probability that a variable drawn from a normal distribution will be between the mean and x standard deviations from the mean. Syntax GAUSS(x) x: The number of standard deviations away from the mean. Eg., 2 Remarks The value of GAUSS will ...GAMMALN
Returns the natural logarithm of the Gamma function. Syntax GAMMALN(x) x: The value for which you want to calculate GAMMALN. Eg., 12 Examples Formula Result GAMMALN(12) 17.502307846 GAMMALN(A3) 2.453736571 GAMMALN(A4) 49.563648282 Get a hands-on ...GAMMAINV
Calculates the inverse of cumulative Gamma distribution function. Syntax GAMMAINV(p; α; β) p: The probability associated with Gamma distribution. Eg., 0.04561309581867 α: A parameter to the distribution (shape). Eg., 5 β: A parameter to the ...GAMMADIST
Returns the value for Gamma distribution. Syntax GAMMADIST(x; α; β; mode) x: The value at which to evaluate the distribution. Eg., 14 α: A parameter for distribution (shape). Eg., 5 β: A parameter for distribution (scale). Eg., 2 mode: The function ...GAMMA
Returns the values of the Gamma function. Syntax GAMMA(x) x: The number whose Gamma function is to be obtained. Eg., 12 Examples Formula Result =GAMMA(12) 39916800 =GAMMA(A3) 11.631728397 =GAMMA(23.35) 3.351344E21 Get a hands-on experience of the ...FTEST
Returns the result of an F-test. Calculates the likelihood that two samples have the same variance. Syntax FTEST(data1; data2) data1: The first array or data range. Eg., A2:A6 data2: The second array or data range. Eg., B2:B4 Examples Formula Result ...FORECAST
Returns the expected y value for a given x value based on linear regression of data. Syntax FORECAST(new_x_value; y_values; x_values) new_x_value: The data point for which to predict a value. Eg., 10 y_values: A single row or column data specifying ...FISHERINV
Calculates the inverse of the Fisher transformation at a given value. Syntax FISHERINV(z) z: The Fisher transformation value whose inverse you want to calculate. Eg., 0.60840023073448 Examples Formula Result =FISHERINV( 0.60840023073448) 0.543 ...FISHER
Returns the Fisher transformation at a given value. Syntax FISHER(r) r: The value at which to calculate the Fisher transformation. Eg., 0.543 Examples Formula Result =FISHER(0.543) 0.608400231 =FISHER(A3) 0.120581028 =FISHER(A4) -0.996215082 Get a ...FINV
Calculates the inverse of right-tailed F probability distribution function. Syntax FINV(p; r1; r2) p: Probability associated with the right-tailed F distribution. Eg., 0.94233111437756 r1: The numerator of the degrees of freedom. Eg., 5 r2: The ...FDIST
Returns the right-tailed F probability distribution (degree of diversity) for two data sets at a given value. Syntax FDIST(x; r1; r2) x: The value at which you want to evaluate the function. Eg., 0.2 r1: The numerator of the degrees of freedom. Eg., ...EXPONDIST
Calculates values for an exponential distribution. Syntax EXPONDIST(x; lambda; mode) x: The value whose exponential distribution function you want to calculate. Eg., 0.3 lambda: The parameter value. This value must be greater than zero. Eg., 5 mode: ...DEVSQ
Returns the sum of squares of deviations from the mean of a given sample. Syntax DEVSQ(number; [number1]; ...) number: The numbers or cell range containing the sample. Eg., A2:A10 Remarks Text, logical values, and empty cells are ignored. Examples ...CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Syntax CRITBINOM(n; p; a) n: Number of independent trials. Eg., 15 p: Probability of success. Eg., 0.3 a: The criterion value. ...COVAR
Returns the covariance of a data point with two sets of data. Syntax COVAR(x; y) x: The cell range containing the first set of data. Eg., A2:A4 y: The cell range containing the second set of data. Eg., B2:B4 Remarks COVAR function ignores text ...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?