53 functions in this category · showing 53 available
Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure. This function is provided for backward compatibility; consider using the WEIBULL.DIST function instead.
Returns the secant of an angle.
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Returns the inverse hyperbolic cotangent of a number.
Returns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Results from the test shows if the difference is statistically significant or from chance. This function is provided for backward compatibility; consider using the T.TEST function instead.
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data. For more information about the new function, see LOGNORM.INV function.
This function returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.
Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE to find the top 25 percent of incomes in a population. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, you should consider using the new functions from now on, it may not be available in future versions of Excel.
Returns the principal value of the arccotangent, or inverse cotangent, of a number.
Returns the confidence interval for a population mean, using a normal distribution. The confidence interval is a range of values. Your sample mean, x, is at the center of this range and the range is x ± CONFIDENCE. For example, if x is the sample mean of delivery times for products ordered through the mail, x ± CONFIDENCE is a range of population means. For any population mean, μ0, in this range, the probability of obtaining a sample mean further from μ0 than x is greater than alpha; for any population mean, μ0, not in this range, the probability of obtaining a sample mean further from μ0 than x is less than alpha. In other words, assume that we use x, standard_dev, and size to construct a two-tailed test at significance level alpha of the hypothesis that the population mean is μ0. Then we will not reject that hypothesis if μ0 is in the confidence interval and will reject that hypothesis if μ0 is not in the confidence interval. The confidence interval does not allow us to infer that there is probability 1 – alpha that our next package will take a delivery time that is in the confidence interval. For more information about the new functions, see CONFIDENCE.NORM function and CONFIDENCE.T function.
Return the cotangent of an angle specified in radians.
Return the hyperbolic cotangent of a hyperbolic angle.
Return the hyperbolic cosecant of an angle specified in radians.
The FDIST function returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. You can use this function to determine whether two data sets have different degrees of diversity.
Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,...), then GAMMAINV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.
Converts text to a number, in a locale-independent way.
Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. If k is non-numeric, PERCENTILE returns the #VALUE! error value. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
Returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK to evaluate the standing of an aptitude test score among all scores for the test. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution. For more information about the new functions, see T.DIST.2T function and T.DIST.RT function.
Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHIDIST(x,...), then CHIINV(probability,...) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid.
Returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.
Returns the individual term binomial distribution probability.
Returns the number of combinations (with repetitions) for a given number of items.
The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings. For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
Returns the error function.
Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPONDIST to determine the probability that the process takes at most 1 minute.
Returns the inverse of the (right-tailed) F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x. The F distribution can be used in an F-test that compares the degree of variability in two data sets. For example, you can analyze income distributions in the United States and Canada to determine whether the two countries have a similar degree of income diversity.
Predicts a future value based on a linear trend (the legacy FORECAST.LINEAR)
Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed. For more information about the new function, see LOGNORM.DIST function.
Returns the standard normal cumulative distribution function.
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. This function is provided for backward compatibility; consider using the NORM.S.INV function instead.
The STDEVP function calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Returns the two-tailed inverse of the Student's t-distribution. This function is provided for backward compatibility; consider using the T.INV.2T function instead.
The BETAINV functionr eturns the inverse of the cumulative beta probability density function for a specified beta distribution.
Returns the cosecant of an angle specified in radians.
Returns the result of an F-test. An F-test returns the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances.
ISO.CEILING returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. However, if the number or the significance is zero, zero is returned.
The MODE function returns the most frequently occurring, or repetitive, value in an array or range of data.
Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent. For example, you need to find 10 people with excellent reflexes, and you know the probability that a candidate has these qualifications is 0.3. NEGBINOMDIST calculates the probability that you will interview a certain number of unqualified candidates before finding all 10 qualified candidates. For more information about the new function, see NEGBINOM.DIST function.
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute. This function is provided for backward compatibility; consider using the POISSON.DIST function instead.
Calculates variance based on the entire population.
Returns the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.
Returns the cumulative beta probability density function. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
Returns the right-tailed probability of the chi-squared distribution. The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid. This function is provided for backward compatibility; consider using the CHISQ.DIST.RT function instead.
Returns covariance, the average of the products of deviations for each data point pair in two data sets. Use covariance to determine the relationship between two data sets. For example, you can examine whether greater income accompanies greater levels of education.
Returns the complementary ERF function integrated between x and infinity.
Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis. This function is provided for backward compatibility; consider using the GAMMA.DIST function instead.
Returns the hyperbolic secant of an angle.
Estimates variance based on a sample. VAR assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VARP. Arguments can either be numbers or names, arrays, or references that contain numbers. This function has been replaced with one or more new functions. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
CRITBINOM function
HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOMDIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.
Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.) For more information about the new functions, see RANK.AVG function and RANK.EQ function.
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered. If the DLL or code resource has not been registered, this function registers the DLL or code resource and then returns the register ID. REGISTER.ID can be used on worksheets (unlike REGISTER), but you cannot specify a function name and argument names with REGISTER.ID. For more information about DLLs and code resources and data types, see Using the CALL and REGISTER functions.