Compatibility Functions

Functions for compatibility with other spreadsheet applications

BETAINV Function

The BETAINV function computes the inverse of the cumulative beta distribution, finding the value x where the cumulative probability equals a given probability. Essential for statistical analysis and project planning to model completion times with variability.

BINOMDIST Function

The BINOMDIST function calculates binomial distribution probabilities for scenarios with fixed trials where each has only success or failure outcomes. Perfect for modeling coin flips, quality control pass/fail rates, or medical test result probabilities.

CHIDIST Function

The CHIDIST function calculates the right-tailed probability of the chi-squared distribution, essential for χ² statistical tests comparing observed vs expected values in hypothesis testing scenarios.

CHIINV Function

The CHIINV function calculates the inverse of the right-tailed chi-squared probability distribution. It finds the critical value x where CHIDIST(x, degrees of freedom) equals the specified probability. Essential for hypothesis testing and statistical analysis.

CHITEST Function

The CHITEST function performs a chi-squared test for independence, comparing observed frequencies against expected values in contingency tables to determine if variables are independent.

CONCATENATE Function

The CONCATENATE function combines multiple text strings, numbers, or cell references into a single text string. It's a fundamental text function for building dynamic text content by joining separate pieces of information.

CONFIDENCE Function

The CONFIDENCE function calculates the margin of error for a population mean using normal distribution assumptions. It helps determine the range within which the true population mean likely falls, based on sample data and a specified confidence level.

COVAR Function

The COVAR function calculates the covariance between two data sets, measuring how two variables change together. Positive covariance indicates that the variables tend to move in the same direction, while negative covariance suggests opposite movement.

CRITBINOM Function

The CRITBINOM function finds the minimum number of successes in a binomial experiment where the cumulative probability reaches or exceeds a specified threshold. Primarily used in quality control to set acceptable defect limits.

EXPONDIST Function

The EXPONDIST function calculates the exponential distribution, commonly used to model time between events in processes like service times or failure rates. It provides both probability density and cumulative distribution values for statistical analysis.

FDIST Function

The FDIST function calculates the right-tailed F probability distribution, helping you compare variance between two datasets. This statistical tool is essential for hypothesis testing to determine if two populations have significantly different degrees of diversity.

FINV Function

The FINV function returns the inverse of the right-tailed F probability distribution, finding the critical F-value for a given probability. Essential for F-tests comparing variability between datasets like income distributions across regions.

FLOOR Function

The FLOOR function rounds a number down to the nearest multiple of a specified significance value. It always rounds toward negative infinity, making it ideal for precise downward rounding in financial calculations, pricing, and data analysis.

FORECAST Function

The FORECAST function predicts future values using linear regression analysis on historical data. It calculates the expected y-value for a specified x-value based on known x and y data points, making it essential for trend analysis and forecasting.

FTEST Function

The Excel FTEST function performs an F-test to compare variances between two data sets, returning the two-tailed probability that their variances are significantly different. This statistical tool helps determine if two samples exhibit different levels of variability.

GAMMADIST Function

The GAMMADIST function calculates the gamma distribution, ideal for analyzing skewed data distributions commonly found in queuing theory, reliability analysis, and process modeling. Note: This legacy function is replaced by GAMMA.DIST for enhanced precision.

GAMMAINV Function

The GAMMAINV function calculates the inverse of the gamma cumulative distribution, returning the value x where the cumulative probability equals a specified value. Ideal for statistical analysis of skewed distributions.

HYPGEOMDIST Function

The HYPGEOMDIST function calculates the hypergeometric probability distribution, determining the likelihood of observing a specific number of successes in a sample drawn without replacement from a finite population containing a known number of successes.

LOGINV Function

The LOGINV function calculates the inverse of the lognormal cumulative distribution, returning the value x where ln(x) follows a normal distribution with specified mean and standard deviation. Essential for statistical analysis of logarithmically transformed datasets.

LOGNORMDIST Function

The LOGNORMDIST function calculates the cumulative lognormal distribution for a specified value, where the natural logarithm of the value follows a normal distribution with given mean and standard deviation parameters. Ideal for modeling skewed positive data like stock prices, asset returns, and time-to-failure analysis.

MODE Function

The Excel MODE function identifies the most frequently occurring value in a dataset, making it perfect for finding the most common scores, ratings, or repeated measurements in your data analysis.

NEGBINOMDIST Function

The NEGBINOMDIST function calculates the negative binomial distribution, giving the probability of experiencing a specific number of failures before achieving a fixed number of successes in independent trials with constant success probability. This legacy function models scenarios where successes are fixed and trials vary.

NORMDIST Function

The NORMDIST function calculates values for the normal (Gaussian) distribution, a fundamental concept in statistics used for modeling real-world phenomena like test scores, heights, and measurement errors. It supports both probability density and cumulative distribution calculations.

NORMINV Function

The NORMINV function calculates the inverse of the normal cumulative distribution, returning the value corresponding to a given probability within a normal distribution defined by its mean and standard deviation. This legacy function finds the x-value where the cumulative distribution function equals the specified probability.

NORMSDIST Function

The NORMSDIST function calculates the cumulative distribution for a standard normal distribution (mean=0, standard deviation=1). This legacy function computes the probability that a standard normal random variable is less than or equal to a given z-score value.

NORMSINV Function

The NORMSINV function returns the inverse of the standard normal cumulative distribution, finding the z-score corresponding to a given probability. It assumes a mean of 0 and standard deviation of 1, essential for statistical analysis and quality control.

PERCENTILE Function

The PERCENTILE function calculates the k-th percentile of a dataset, helping you identify threshold values within your data distribution. This legacy function uses inclusive interpolation methodology and remains available for backward compatibility.

PERCENTRANK Function

The PERCENTRANK function calculates the relative position of a specific value within a dataset, expressed as a percentage rank (0-1 scale). It shows how a value compares to the entire data range, useful for percentile analysis and performance ranking.

POISSON Function

The POISSON function calculates probabilities from the Poisson distribution, ideal for modeling the number of events occurring within a fixed interval of time or space when these events happen independently at a constant average rate.

QUARTILE Function

The QUARTILE function calculates quartile values from a dataset, dividing data into four equal parts for statistical analysis. This legacy function identifies minimum, first quartile (25th percentile), median, third quartile (75th percentile), or maximum values.

RANK Function

The RANK function determines a number's position within a dataset, showing how it compares to other values. It assigns ranks based on relative size - highest values get rank 1 in descending order (default) or lowest values get rank 1 in ascending order.

STDEV Function

The STDEV function estimates the standard deviation of a sample dataset, measuring how much individual data points vary from the mean value. This statistical function uses the 'n-1' method for unbiased sample variance estimation.

STDEVP Function

The STDEVP function calculates the standard deviation for an entire population dataset. This statistical function measures how much individual data points vary from the population mean, using the complete 'n' divisor method for population analysis.

TDIST Function

The TDIST function calculates probability values for the Student t-distribution, essential for statistical hypothesis testing with small sample datasets. It provides the percentage points (probability) for a given t-value, serving as a digital alternative to traditional t-distribution tables.

TINV Function

The TINV function calculates the two-tailed inverse of the Student's t-distribution, returning the critical t-value for a given probability and degrees of freedom. This legacy function is essential for statistical hypothesis testing but Microsoft recommends using the more precise T.INV.2T function in modern Excel versions.

TTEST Function

The TTEST function calculates the probability value associated with a Student's t-Test, helping you determine if two data sets are likely from populations with identical means. This statistical tool is essential for hypothesis testing in data analysis.

VAR Function

The VAR function calculates the variance of a sample dataset, measuring how spread out the values are from their average. This statistical function assumes your data represents a sample rather than the entire population.

VARP Function

The VARP function calculates variance for an entire population dataset in Excel. Use it when your data represents the complete set of values rather than just a sample.

WEIBULL Function

The WEIBULL function calculates the Weibull distribution, widely used in reliability engineering to model time-to-failure data for products and systems. It provides both probability density and cumulative distribution values essential for life testing and survival analysis.

ZTEST Function

The ZTEST function performs a one-tailed z-test to determine the probability that the sample mean is greater than a hypothesized population mean. It calculates the p-value associated with a z-statistic for hypothesis testing.