SpreadJS 14
Formula Reference / Formula Functions / Compatibility Functions
In This Topic
    Compatibility Functions
    In This Topic

    Spread provides the following compatibility functions, listed alphabetically.

    Function Description
    BETADIST This function calculates the cumulative beta distribution function.
    BETAINV This function calculates the inverse of the cumulative beta distribution function.
    BINOMDIST This function calculates the individual term binomial distribution probability.
    CHIDIST This function calculates the one-tailed probability of the chi-squared distribution.
    CHIINV This function calculates the inverse of the one-tailed probability of the chi-squared distribution.
    CHITEST This function calculates the test for independence from the chi-squared distribution.
    CONFIDENCE This function returns confidence interval for a population mean.
    COVAR This function returns the covariance, which is the average of the products of deviations for each data point pair in two sets of numbers.
    CRITBINOM This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
    EXPONDIST This function returns the exponential distribution or the probability density.
    FDIST This function calculates the F probability distribution, to see degrees of diversity between two sets of data.
    FLOOR This function rounds a number down to the nearest multiple of a specified value.
    FTEST This function returns the result of an F-test, which returns the one-tailed probability that the variances in two arrays are not significantly different.
    GAMMADIST This function returns the gamma distribution.
    GAMMAINV This function returns the inverse of the gamma cumulative distribution.
    HYPGEOMDIST This function returns the hypergeometric distribution.
    LOGINV This function returns the inverse of the lognormal cumulative distribution function of x, where LN(x) is normally distributed with the specified mean and standard deviation.
    LOGNORMDIST This function returns the cumulative natural log normal distribution of x, where LN(x) is normally distributed with the specified mean and standard deviation. Analyze data that has been logarithmically transformed with this function.
    MODE This function returns the most frequently occurring value in a set of data.
    NEGBINOMDIST This function returns the negative binomial distribution.
    NORM.INV This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation.
    NORMDIST This function returns the normal cumulative distribution for the specified mean and standard deviation.
    NORMSDIST This function returns the standard normal cumulative distribution function.
    NORMSINV This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
    PERCENTILE This function returns the nth percentile of values in a range.
    PERCENTRANK This function returns the rank of a value in a data set as a percentage of the data set.
    POISSON This function returns the Poisson distribution.
    QUARTILE This function returns which quartile (which quarter or 25 percent) of a data set a value is.
    RANK This function returns the rank of a number in a set of numbers. If you were to sort the set, the rank of the number would be its position in the list.
    STDEV This function returns the standard deviation for a set of numbers.
    STDEVP This function returns the standard deviation for an entire specified population (of numeric values).
    TDIST This function returns the probability for the t-distribution.
    TINV This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom.
    TTEST This function returns the probability associated with a t-test.
    VAR This function returns the variance based on a sample of a population, which uses only numeric values.
    VARP This function returns variance based on the entire population, which uses only numeric values.
    WEIBULL This function returns the two-parameter Weibull distribution, often used in reliability analysis.
    ZTEST This function returns the significance value of a z-test. The z-test generates a standard score for x with respect to the set of data and returns the two-tailed probability for the normal distribution.