Statistical Functions
Statistical analysis functions
AVEDEV Function
The Excel AVEDEV function calculates the average of the absolute deviations of data points from their arithmetic mean, providing a measure of variability that shows how spread out values are from the center.
Learn MoreAVERAGE Function
The AVERAGE function calculates the arithmetic mean of a set of numeric values, ignoring text, logical values, and empty cells while including zeros. It's the most fundamental statistical function for finding central tendency in datasets.
Learn MoreAVERAGEA Function
The AVERAGEA function calculates the arithmetic mean of a dataset, uniquely including logical values (TRUE/FALSE) and text representations of numbers in the calculation. Unlike standard AVERAGE, it treats TRUE as 1, FALSE as 0, and numeric text as its value, providing more comprehensive averaging across mixed data types.
Learn MoreAVERAGEIF Function
The AVERAGEIF function calculates the arithmetic mean of numbers in a specified range that satisfy a given condition. This powerful tool enables conditional averaging without complex array formulas or helper columns.
Learn MoreAVERAGEIFS Function
The AVERAGEIFS function calculates the arithmetic mean of cells within a specified range that satisfy multiple user-defined criteria simultaneously. This powerful statistical tool enables precise data analysis by filtering datasets based on complex conditions.
Learn MoreBETA.DIST Function
The BETA.DIST function calculates the beta distribution, a flexible continuous probability distribution used to model variability in proportions and percentages across different samples. It's particularly valuable for quality control, project management, and Bayesian statistical analysis.
Learn MoreBETA.INV Function
The BETA.INV function calculates the inverse of the cumulative beta distribution, returning the value x where the cumulative probability matches the specified probability. This advanced statistical function is essential for project management, risk analysis, and modeling continuous variables bounded between two limits.
Learn MoreBETADIST Function
The BETADIST function calculates the cumulative beta probability density, ideal for modeling proportions and percentages across sample data. This legacy function analyzes variation in fractional data like time allocation or success rates.
Learn MoreBINOM.DIST Function
The BINOM.DIST function calculates binomial distribution probabilities for scenarios with a fixed number of independent trials, each having only two possible outcomes: success or failure. It supports both individual term probability and cumulative distribution calculations.
Learn MoreBINOM.DIST.RANGE Function
The BINOM.DIST.RANGE function calculates the probability of achieving a specific number of successes—or a range of successes—in a fixed number of independent trials, each with the same probability of success. This is essential for binomial distribution analysis in quality control, risk assessment, and statistical modeling.
Learn MoreBINOM.INV Function
The BINOM.INV function returns the smallest integer k such that the cumulative binomial probability for k successes in n trials is greater than or equal to a specified threshold. Essential for binomial inverse distribution calculations in statistical analysis.
Learn MoreCHISQ.DIST Function
The CHISQ.DIST function calculates the chi-squared distribution, essential for statistical analysis of variance across samples. It supports both cumulative distribution (CDF) and probability density (PDF) calculations based on the cumulative parameter.
Learn MoreCHISQ.DIST.RT Function
The CHISQ.DIST.RT function calculates the right-tailed probability of the chi-squared distribution, essential for chi-squared statistical tests comparing observed vs expected values in hypothesis testing scenarios.
Learn MoreCHISQ.INV Function
The CHISQ.INV function calculates the inverse of the left-tailed chi-squared distribution, returning the chi-squared value for a given cumulative probability and degrees of freedom. Essential for statistical hypothesis testing and confidence interval calculations.
Learn MoreCHISQ.INV.RT Function
The CHISQ.INV.RT function returns the inverse of the right-tailed chi-squared distribution probability, finding the critical value x where CHISQ.DIST.RT(x, degrees of freedom) equals the specified probability. Ideal for hypothesis testing and statistical analysis.
Learn MoreCHISQ.TEST Function
The CHISQ.TEST function performs a chi-squared test for independence, comparing observed categorical data against expected frequencies to determine if observed patterns occurred by chance or indicate true association.
Learn MoreCONFIDENCE.NORM Function
The CONFIDENCE.NORM function calculates the confidence interval margin for a population mean using the normal distribution assumption. It helps determine a range around your sample mean where the true population mean is likely to fall with a specified confidence level.
Learn MoreCONFIDENCE.T Function
The CONFIDENCE.T function calculates the confidence interval for a population mean when the population standard deviation is known, using the Student's t-distribution. This is essential for statistical analysis when working with small sample sizes where the normal distribution assumption doesn't hold.
Learn MoreCORREL Function
The Excel CORREL function calculates the correlation coefficient between two data sets, measuring the strength and direction of their linear relationship. Values range from -1 to +1, where 1 indicates perfect positive correlation, -1 perfect negative correlation, and 0 no linear relationship.
Learn MoreCOUNT Function
The COUNT function tallies numeric values within a range or list of arguments, ignoring text, logical values, and errors. Perfect for quantifying data entries in spreadsheets.
Learn MoreCOUNTA Function
The COUNTA function in Excel counts all non-empty cells within a specified range or list of values. Unlike COUNT which only tallies numeric values, COUNTA includes text, logical values, errors, and formulas returning empty strings (\"\").
Learn MoreCOUNTBLANK Function
The COUNTBLANK function is a statistical tool that counts empty cells within a specified range, making it essential for data cleaning and validation tasks in Excel spreadsheets.
Learn MoreCOUNTIF Function
The COUNTIF function is a powerful statistical tool that counts the number of cells within a specified range that meet a single given criterion. Perfect for data analysis tasks like tracking occurrences, filtering conditions, and generating summary statistics from large datasets.
Learn MoreCOUNTIFS Function
The COUNTIFS function counts the number of cells within multiple specified ranges that meet all given criteria simultaneously. It extends COUNTIF functionality to handle complex multi-condition counting scenarios across corresponding cell positions.
Learn MoreCOVARIANCE.P Function
The COVARIANCE.P function calculates the population covariance between two data sets, measuring how much two variables change together. Positive covariance indicates that both variables tend to increase or decrease together, while negative covariance shows they move in opposite directions.
Learn MoreCOVARIANCE.S Function
The COVARIANCE.S function calculates the sample covariance between two data sets, measuring how two variables change together. It returns the average of the products of paired deviations from their respective means.
Learn MoreDEVSQ Function
The DEVSQ function calculates the sum of the squared deviations of a set of values from their sample mean. This is a key statistical measure used in variance calculations and regression analysis.
Learn MoreEXPON.DIST Function
The EXPON.DIST function calculates the exponential distribution, ideal for modeling time between events in processes like service times or failure intervals. It provides both probability density and cumulative distribution values for statistical analysis.
Learn MoreF.DIST Function
The F.DIST function calculates the F probability distribution, helping you compare variance between two datasets. It's essential for statistical analysis to test if two groups have significantly different spreads or dispersions.
Learn MoreF.DIST.RT Function
The F.DIST.RT function calculates the right-tailed F probability distribution, helping you determine if two datasets have significantly different variances. Ideal for statistical analysis comparing variability between groups like test scores across demographics.
Learn MoreF.INV Function
The F.INV function returns the inverse of the left-tailed F probability distribution. Given a probability value, it calculates the corresponding F critical value for specified degrees of freedom, essential for F-tests comparing variability between datasets.
Learn MoreF.INV.RT Function
The F.INV.RT function returns the inverse of the right-tailed F probability distribution, enabling precise calculation of critical F-values for statistical analysis and hypothesis testing.
Learn MoreF.TEST Function
The Excel F.TEST function performs an F-test to determine if two datasets have significantly different variances. It returns the two-tailed probability that the variances in two arrays are not significantly different.
Learn MoreFISHER Function
The Excel FISHER function applies the Fisher transformation to a correlation coefficient, converting it into a normally distributed value. This statistical tool is essential for hypothesis testing on correlation coefficients, stabilizing variance and enabling reliable analysis of relationships between variables.
Learn MoreFISHERINV Function
The FISHERINV function performs the inverse Fisher transformation, converting a normally distributed z-score back to a correlation coefficient. Essential for statistical analysis of correlations between datasets.
Learn MoreFORECAST.ETS Function
FORECAST.ETS leverages advanced Exponential Triple Smoothing (ETS) algorithms to deliver accurate time series predictions. This powerful function automatically detects seasonality patterns and provides reliable forecasts for business planning, sales projections, and trend analysis.
Learn MoreFORECAST.ETS.CONFINT Function
The FORECAST.ETS.CONFINT function returns a confidence interval for an exponential triple smoothing (ETS) forecast, providing a statistical range within which the actual future value is expected to fall with a specified probability.
Learn MoreFORECAST.ETS.SEASONALITY Function
The FORECAST.ETS.SEASONALITY function analyzes historical time series data to automatically detect and return the length of the seasonal pattern. This advanced forecasting tool uses Exponential Triple Smoothing (ETS) algorithms to identify repeating cycles in your data without manual pattern specification.
Learn MoreFORECAST.ETS.STAT Function
The FORECAST.ETS.STAT function returns specified statistical values from the underlying ETS forecast model, providing insights into model parameters, accuracy metrics, and forecast reliability for advanced time series analysis.
Learn MoreFORECAST.LINEAR Function
The FORECAST.LINEAR function predicts a future value using simple linear regression analysis. It calculates the best-fit straight line through known data points and extends it to estimate values for new x-values, making it ideal for trend analysis and basic forecasting.
Learn MoreFREQUENCY Function
The FREQUENCY function creates a histogram by counting how many values from a dataset fall into specified ranges or bins. It returns a vertical array where each element shows the frequency of values within each bin, plus an extra count for values exceeding the highest bin.
Learn MoreGAMMA Function
The Excel GAMMA function calculates the gamma function value for a given number, a key mathematical function used in statistics, probability theory, and advanced calculations. It extends the factorial function to real and complex numbers.
Learn MoreGAMMA.DIST Function
The GAMMA.DIST function in Excel calculates the gamma distribution, ideal for modeling skewed data and time-to-event scenarios. Use it for queuing analysis, reliability engineering, and statistical modeling where traditional normal distributions don't fit.
Learn MoreGAMMA.INV Function
The GAMMA.INV function returns the inverse of the gamma cumulative distribution, solving for the value x where GAMMA.DIST(x,alpha,beta,TRUE) equals a specified probability. Ideal for statistical analysis of skewed distributions like waiting times or project durations.
Learn MoreGAMMALN Function
The GAMMALN function computes the natural logarithm of the gamma function, Γ(x), providing essential functionality for statistical calculations, probability distributions, and advanced mathematical analysis in Excel.
Learn MoreGAMMALN.PRECISE Function
The GAMMALN.PRECISE function computes the natural logarithm of the gamma function Γ(x), providing precise mathematical calculations for statistical analysis, probability distributions, and advanced numerical computations in Excel.
Learn MoreGAUSS Function
The GAUSS function calculates the probability that a value from a standard normal distribution falls between the population mean (zero) and a specified number of standard deviations (z). This is useful for statistical analysis and quality control applications.
Learn MoreGEOMEAN Function
The Excel GEOMEAN function calculates the geometric mean of a range of positive numbers, ideal for measuring average growth rates over multiple periods like compound interest or multiplicative processes.
Learn MoreGROWTH Function
The GROWTH function predicts future values using exponential regression analysis. It calculates y-values for new x-values based on existing data points following the exponential relationship y = b*m^x, perfect for modeling compound growth, population expansion, or any exponentially increasing trends.
Learn MoreHARMEAN Function
The Excel HARMEAN function calculates the harmonic mean of a dataset. The harmonic mean is the reciprocal of the arithmetic mean of the reciprocals, making it ideal for averaging rates, ratios, and per-unit measurements where the same total denominator applies to all values.
Learn MoreHYPGEOM.DIST Function
The HYPGEOM.DIST function calculates the hypergeometric distribution, which models the probability of achieving a specific number of successes in a sample drawn without replacement from a finite population containing a known number of successes. This is essential for quality control, survey analysis, and finite population sampling scenarios.
Learn MoreINTERCEPT Function
The INTERCEPT function calculates the y-axis intersection point of the best-fit regression line through provided x-values and y-values. It determines the dependent variable value when the independent variable equals zero, making it essential for linear trend extrapolation.
Learn MoreKURT Function
The Excel KURT function measures the kurtosis of a dataset, quantifying how peaked or flat the distribution is compared to a normal distribution. Positive values indicate leptokurtic (peaked) distributions with heavy tails, while negative values show platykurtic (flat) distributions.
Learn MoreLARGE Function
The Excel LARGE function returns the k-th largest value from a dataset, enabling you to identify top performers, highest scores, or any specific rank position from largest to smallest within your data range.
Learn MoreLINEST Function
The LINEST function performs linear regression analysis using the least squares method to find the best-fitting straight line through your data points. It returns an array containing slope coefficients, intercept, and optional comprehensive regression statistics for advanced data modeling and forecasting.
Learn MoreLOGEST Function
The LOGEST function performs exponential regression analysis, fitting an exponential curve y = b*m^x to your data and returning the growth parameters as an array. Essential for modeling exponential growth patterns like population growth, compound interest, or biological processes.
Learn MoreLOGNORM.DIST Function
The LOGNORM.DIST function calculates the lognormal distribution for a specified value, where the natural logarithm of x follows a normal distribution defined by mean and standard deviation parameters. Essential for statistical analysis of positively skewed data like stock prices, sizes, and durations.
Learn MoreLOGNORM.INV Function
The LOGNORM.INV function returns the inverse of the lognormal cumulative distribution function. It finds the value x where the natural log of x follows a normal distribution with specified mean and standard deviation, given a particular probability.
Learn MoreMAX Function
The MAX function in Excel returns the largest numeric value from a set of numbers, ranges, or arrays. It efficiently identifies the highest value across multiple inputs, ignoring non-numeric data like text and empty cells.
Learn MoreMAXA Function
The MAXA function in Excel finds the maximum value from a list of arguments, uniquely including logical values (TRUE=1, FALSE=0) and text representations of numbers while ignoring empty cells and non-numeric text.
Learn MoreMAXIFS Function
The MAXIFS function returns the maximum numeric value from a specified range that meets multiple user-defined criteria. This powerful conditional maximum function enables precise data analysis by filtering datasets based on complex conditions across multiple columns.
Learn MoreMEDIAN Function
The Excel MEDIAN function returns the middle value from a set of numbers, providing a robust measure of central tendency that's less affected by extreme values than the arithmetic average. Perfect for skewed datasets and statistical analysis.
Learn MoreMIN Function
The Excel MIN function returns the smallest numeric value from a set of numbers, ranges, or arrays. It's essential for finding minimum values in datasets for statistical analysis, performance tracking, and data validation.
Learn MoreMINA Function
The Excel MINA function returns the smallest numeric value from a set of arguments, uniquely treating logical TRUE as 1 and any text or FALSE as 0. Unlike standard minimum functions, MINA considers non-numeric data in calculations for more comprehensive minimum value detection.
Learn MoreMINIFS Function
The MINIFS function finds the smallest numeric value in a range that meets multiple specified criteria. It's perfect for conditional minimum calculations across complex datasets without needing array formulas or helper columns.
Learn MoreMODE.MULT Function
The MODE.MULT function returns a vertical array containing all the most frequent values (modes) from a dataset. Unlike MODE.SNGL which returns only one mode, MODE.MULT captures multiple modes when they exist, making it perfect for datasets with several equally frequent values.
Learn MoreMODE.SNGL Function
The MODE.SNGL function identifies the most frequently occurring value (mode) in a dataset, helping you discover the most common number in sales records, test scores, or any numerical data. Essential for statistical analysis and data pattern recognition.
Learn MoreNEGBINOM.DIST Function
The NEGBINOM.DIST function calculates the negative binomial distribution, determining the probability of a specified number of failures before achieving a fixed number of successes in independent trials. This advanced statistical tool is essential for modeling scenarios where success count is fixed but failure trials vary.
Learn MoreNORM.DIST Function
The NORM.DIST function calculates the normal distribution for specified mean and standard deviation values. Essential for statistical analysis, it provides both probability density (PDF) and cumulative distribution (CDF) values for hypothesis testing, quality control, and risk assessment.
Learn MoreNORM.INV Function
The NORM.INV function returns the inverse of the normal cumulative distribution, finding the value corresponding to a given probability within a specified normal distribution defined by its mean and standard deviation.
Learn MoreNORM.S.DIST Function
The NORM.S.DIST function calculates values for the standard normal distribution (mean=0, standard deviation=1). It provides either the cumulative probability (area under the curve to the left of z) or the probability density at a specific z-value, serving as a digital replacement for Z-tables in statistics.
Learn MoreNORM.S.INV Function
The NORM.S.INV function returns the inverse of the standard normal cumulative distribution, finding the z-score that corresponds to a given probability under a normal distribution with mean 0 and standard deviation 1.
Learn MorePEARSON Function
The PEARSON function calculates the Pearson product-moment correlation coefficient, measuring the linear relationship strength between two data sets. Values range from -1.0 (perfect negative correlation) to +1.0 (perfect positive correlation), with 0 indicating no linear relationship.
Learn MorePERCENTILE.EXC Function
The PERCENTILE.EXC function calculates the exclusive k-th percentile value from a dataset, using a method that excludes the minimum (0th) and maximum (100th) percentiles. Ideal for statistical analysis requiring strict percentile boundaries between 0 and 1 exclusive.
Learn MorePERCENTILE.INC Function
The PERCENTILE.INC function calculates the k-th percentile of a dataset, where k ranges from 0 to 1 inclusive. This statistical function helps identify specific percentile values for data analysis and threshold setting.
Learn MorePERCENTRANK.EXC Function
The PERCENTRANK.EXC function calculates the percentage rank of a specific value within a dataset, returning a value between 0 (exclusive) and 1 (exclusive). This exclusive ranking method provides precise percentile positioning ideal for statistical analysis and data distribution studies.
Learn MorePERCENTRANK.INC Function
The PERCENTRANK.INC function calculates the relative position of a specific value within a dataset, expressed as a percentage between 0 and 1 (inclusive). Perfect for percentile rankings in performance metrics, test scores, or any comparative analysis.
Learn MorePERMUT Function
The PERMUT function calculates the number of permutations possible from a set of objects, where the order of selection matters. Essential for probability calculations, lottery analysis, and combinatorial problems where arrangement sequence is significant.
Learn MorePERMUTATIONA Function
The PERMUTATIONA function calculates the number of permutations possible when selecting a specific number of objects from a larger set, allowing repetitions. Unlike standard permutations, this function accounts for scenarios where the same object can be chosen multiple times in different positions.
Learn MorePHI Function
The PHI function calculates the value of the probability density function for a standard normal distribution (mean 0, standard deviation 1) at a given point. This is essential for statistical analysis, probability calculations, and financial modeling involving normal distributions.
Learn MorePOISSON.DIST Function
The POISSON.DIST function calculates Poisson distribution probabilities, 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.
Learn MorePROB Function
The Excel PROB function calculates the probability that values within a specified range fall between two given limits. It's an essential statistical tool for discrete probability distributions, enabling precise probability calculations for specific value ranges or exact matches.
Learn MoreQUARTILE.EXC Function
The QUARTILE.EXC function calculates quartile values from a dataset using exclusive percentile methods, returning the 1st (25th percentile), 2nd (50th percentile/median), or 3rd (75th percentile) quartile. Unlike inclusive methods, it excludes the minimum and maximum values from endpoint calculations.
Learn MoreQUARTILE.INC Function
The QUARTILE.INC function calculates quartile values from a dataset using the inclusive method, which includes the minimum and maximum values as quartiles 0 and 4. This statistical function helps divide data into four equal parts for analysis of distributions, outliers, and performance metrics.
Learn MoreRANK.AVG Function
The RANK.AVG function determines a number's position within a dataset, returning the average rank when duplicate values exist. This makes it ideal for accurate percentile analysis and competition scoring where ties need fair representation.
Learn MoreRANK.EQ Function
The RANK.EQ function determines the relative position of a specific number within a dataset. Unlike traditional ranking that skips positions for ties, RANK.EQ assigns the highest rank to tied values while adjusting subsequent ranks accordingly.
Learn MoreRSQ Function
The RSQ function in Excel calculates the square of the Pearson product moment correlation coefficient (r²) between two sets of data points. This value represents the proportion of variance in the dependent variable (y) explained by the independent variable (x), making it essential for regression analysis and statistical modeling.
Learn MoreSKEW Function
The Excel SKEW function measures the asymmetry of a data distribution around its mean. Positive values indicate right-skewed distributions with longer tails toward higher values, while negative values show left-skewed distributions with tails extending toward lower values.
Learn MoreSKEW.P Function
The SKEW.P function calculates the skewness of a population dataset, measuring the asymmetry of the distribution around its mean. Positive skewness indicates a right-tailed distribution, negative skewness a left-tailed one, and zero suggests symmetry.
Learn MoreSLOPE Function
The Excel SLOPE function calculates the slope of the linear regression line through specified data points, representing the rate of change between dependent y-values and independent x-values. Essential for trend analysis and forecasting.
Learn MoreSMALL Function
The Excel SMALL function returns the k-th smallest value from a dataset, perfect for ranking analysis, percentile calculations, and identifying specific order statistics within numerical data.
Learn MoreSTANDARDIZE Function
The Excel STANDARDIZE function converts a value into a normalized z-score based on the mean and standard deviation of a dataset. This statistical function is essential for comparing values from different distributions on a common scale.
Learn MoreSTDEV.P Function
The STDEV.P function calculates the standard deviation for an entire population dataset. It measures how much individual data points vary from the population mean using the 'n' divisor method, perfect for complete datasets like all products in a batch.
Learn MoreSTDEV.S Function
The STDEV.S function estimates the standard deviation of a sample dataset, measuring how much individual data points vary from the mean. Perfect for statistical analysis when working with representative samples rather than complete populations.
Learn MoreSTDEVA Function
The Excel STDEVA function calculates the standard deviation for a sample, uniquely including text and logical values in the analysis. TRUE counts as 1, FALSE and text count as 0, providing comprehensive variability measurement across mixed data types.
Learn MoreSTDEVPA Function
The STDEVPA function calculates the standard deviation for an entire population, uniquely including text and logical values in the computation. It measures the dispersion of data points from their mean, treating TRUE as 1, FALSE as 0, and numeric text as numbers.
Learn MoreSTEYX Function
The Excel STEYX function calculates the standard error of the predicted y-value for each x-value in a linear regression analysis. This metric quantifies the accuracy of predictions made by the regression line, helping you understand the reliability of your forecasting model.
Learn MoreT.DIST Function
The T.DIST function calculates the Student's left-tailed t-distribution, essential for statistical hypothesis testing with small sample datasets. This function replaces traditional t-distribution tables by providing precise probability values directly within Excel.
Learn MoreT.DIST.2T Function
The T.DIST.2T function calculates the two-tailed probability of the Student's t-distribution, essential for statistical hypothesis testing with small sample datasets. It replaces traditional t-distribution tables by providing precise probability values directly within Excel formulas.
Learn MoreT.DIST.RT Function
The T.DIST.RT function calculates the right-tailed probability of the Student's t-distribution, essential for statistical hypothesis testing with small sample sizes. It replaces traditional t-distribution tables by providing precise probability values directly within Excel.
Learn MoreT.INV Function
The Excel T.INV function returns the left-tailed inverse of the Student's t-distribution, providing the critical t-value for a given probability and degrees of freedom. Essential for hypothesis testing and confidence intervals in statistical analysis.
Learn MoreT.INV.2T Function
The T.INV.2T 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. Essential for hypothesis testing and confidence intervals in statistical analysis.
Learn MoreT.TEST Function
The Excel T.TEST function calculates the probability associated with a Student's t-Test, helping you determine if two data sets are likely from populations with the same mean. Essential for statistical analysis and hypothesis testing in Excel.
Learn MoreTREND Function
The TREND function forecasts future values using linear regression analysis. It calculates the best-fitting straight line through known data points and predicts corresponding y-values for new x-values you specify.
Learn MoreTRIMMEAN Function
The Excel TRIMMEAN function calculates the mean of a dataset by excluding a specified percentage of the highest and lowest values. This trimmed mean provides a more robust average that minimizes the impact of outliers and extreme values in statistical analysis.
Learn MoreVAR.P Function
The VAR.P function calculates the variance for an entire population dataset in Excel. It uses the population variance formula, which divides by the total number of data points rather than n-1 used in sample variance.
Learn MoreVAR.S Function
The VAR.S function calculates the sample variance of a dataset, measuring the spread of values around the mean. It treats the data as a sample from a larger population and ignores text, logical values, and empty cells.
Learn MoreVARA Function
The VARA function calculates sample variance from a dataset, uniquely including logical values (TRUE/FALSE) and text representations of numbers in the computation. Unlike standard variance functions, VARA treats TRUE as 1 and FALSE/text as 0, providing more comprehensive statistical analysis of mixed data types.
Learn MoreVARPA Function
The VARPA function calculates variance for an entire population, including numbers, text representations of numbers, and logical values (TRUE/FALSE) in your dataset. Unlike VARP, it treats text as 0 and TRUE as 1, providing comprehensive population variance analysis.
Learn MoreWEIBULL.DIST Function
The WEIBULL.DIST function calculates the Weibull probability distribution, essential for reliability engineering and life data analysis. It models failure rates and time-to-failure scenarios for products and systems.
Learn MoreZ.TEST Function
The Z.TEST function performs a one-tailed z-test, returning the probability that the sample mean from your data exceeds a specified hypothesized population mean. This statistical tool helps determine if your sample data significantly differs from an expected population value.
Learn More